/*
MySQL Backup
Database: drinkshop
Backup Time: 2024-11-27 08:31:29
*/

SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `drinkshop`.`shop_goods`;
DROP TABLE IF EXISTS `drinkshop`.`shop_goods_category`;
DROP TABLE IF EXISTS `drinkshop`.`shop_goods_property`;
DROP TABLE IF EXISTS `drinkshop`.`shop_home`;
DROP TABLE IF EXISTS `drinkshop`.`shop_order_info`;
DROP TABLE IF EXISTS `drinkshop`.`shop_sys_role`;
DROP TABLE IF EXISTS `drinkshop`.`shop_sys_role_permission`;
DROP TABLE IF EXISTS `drinkshop`.`shop_sys_user`;
DROP TABLE IF EXISTS `drinkshop`.`shop_user`;
CREATE TABLE `shop_goods` (
                              `id` int(10) NOT NULL AUTO_INCREMENT,
                              `goods_category_name` varchar(10) NOT NULL,
                              `name` varchar(30) NOT NULL,
                              `display_order` int(10) NOT NULL DEFAULT '0' COMMENT '显示次序',
                              `default_price` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '默认价格',
                              `is_sell` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否在卖',
                              `image` varchar(300) DEFAULT NULL COMMENT '商品图片',
                              `description` varchar(100) DEFAULT '' COMMENT '描述',
                              PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='商品表';
CREATE TABLE `shop_goods_category`  (
                                        `id` int(10) NOT NULL AUTO_INCREMENT,
                                        `name` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品名称',
                                        `display_order` tinyint(1) DEFAULT 1 COMMENT '显示顺序',
                                        `show_status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否显示',
                                        PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品类别表' ROW_FORMAT = Dynamic;
CREATE TABLE `shop_goods_property` (
                                       `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
                                       `goods_id` int(10) NOT NULL,
                                       `category` enum('大小','加料','温度','甜度','口味') NOT NULL COMMENT '内置的属性类型',
                                       `property_option` varchar(10) DEFAULT NULL COMMENT '可选项，eg: 常温',
                                       `is_default` tinyint(1) DEFAULT '0' COMMENT '是否作为默认选择',
                                       `rebase_price` int(10) DEFAULT NULL COMMENT '重置基础价格,只有选择大小属性时需要',
                                       `extra_price` int(10) NOT NULL DEFAULT '0' COMMENT '额外价格',
                                       PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2727 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='商品属性，甜度，温度等';
CREATE TABLE `shop_home` (
                             `id` int(11) NOT NULL COMMENT 'id',
                             `type_id` int(11) DEFAULT NULL,
                             `img` varchar(128) DEFAULT NULL COMMENT '商品轮播',
                             `product_id` int(11) DEFAULT NULL,
                             `sort` tinyint(4) DEFAULT NULL,
                             PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
CREATE TABLE `shop_order_info`  (
                                    `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
                                    `order_no` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单号',
                                    `wx_openid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
                                    `order_status` enum('未付款','制作中','请取餐','配送中','已送达','已完成','已取消','退款中','已退款') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单状态',
                                    `payjs_order_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
                                    `wx_pay_transaction_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '微信支付系统生成的订单号',
                                    `take_type` enum('到店自取','外卖配送') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '取餐方式',
                                    `address_detail` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '收货地址',
                                    `goods_preview` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品信息eg: 奶茶*2',
                                    `goods_total_num` int(11) DEFAULT 0 COMMENT '商品总数',
                                    `total_price` int(10) UNSIGNED DEFAULT NULL,
                                    `pay_price` int(10) UNSIGNED DEFAULT NULL COMMENT '支付金额',
                                    `verify_num` int(11) DEFAULT 0 COMMENT '取单号，一般取手机尾号',
                                    `extra_info` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户备注、订单取消原因、或其他额外信息',
                                    `create_time` datetime(0) NOT NULL DEFAULT '2021-01-01 00:00:00' COMMENT '下单时间',
                                    `pay_time` datetime(0) DEFAULT NULL COMMENT '支付时间',
                                    `finish_time` datetime(0) DEFAULT NULL COMMENT '订单完成时间',
                                    `user_phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户联系电话',
                                    `receiver` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '取餐人',
                                    PRIMARY KEY (`id`) USING BTREE,
                                    INDEX `createTime`(`create_time`) USING BTREE,
                                    INDEX `wx_openid`(`wx_openid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 107 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '订单' ROW_FORMAT = Dynamic;


CREATE TABLE `shop_sys_role` (
                                 `id` int(10) NOT NULL AUTO_INCREMENT,
                                 `name` varchar(20) DEFAULT NULL,
                                 `description` varchar(30) DEFAULT NULL,
                                 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
CREATE TABLE `shop_sys_role_permission` (
                                            `role_id` int(10) NOT NULL,
                                            `permission` varchar(30) NOT NULL COMMENT '权限 eg:system:user:add',
                                            PRIMARY KEY (`role_id`,`permission`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='角色的权限(可以不止一个)';
CREATE TABLE `shop_sys_user` (
                                 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
                                 `username` varchar(10) NOT NULL,
                                 `password` varchar(50) NOT NULL,
                                 `role_id` int(10) DEFAULT NULL,
                                 `status` tinyint(1) DEFAULT '1' COMMENT '1表示账号可用',
                                 `avatar` varchar(30) DEFAULT NULL COMMENT '管理员头像',
                                 PRIMARY KEY (`id`),
                                 UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
CREATE TABLE `shop_user` (
                             `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
                             `name` varchar(32) NOT NULL DEFAULT '' COMMENT '用户名',
                             `password` varchar(32) NOT NULL DEFAULT '' COMMENT '密码',
                             `salt` varchar(32) NOT NULL DEFAULT '' COMMENT '密码salt',
                             `address` varchar(30) CHARACTER SET utf8 NOT NULL COMMENT '地址信息',
                             `gender` tinyint(1) NOT NULL DEFAULT '1' COMMENT '性别',
                             `email` varchar(100) NOT NULL DEFAULT '' COMMENT '邮箱',
                             `phone` varchar(32) NOT NULL DEFAULT '' COMMENT '电话',
                             `avatar` varchar(128) DEFAULT NULL COMMENT '头像',
                             `nick_name` varchar(128) DEFAULT NULL COMMENT '昵称',
                             `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                             `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                             `remark` varchar(256) DEFAULT NULL COMMENT '备注',
                             `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态',
                             PRIMARY KEY (`id`),
                             UNIQUE KEY `username` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COMMENT='注册用户';
BEGIN;
LOCK TABLES `drinkshop`.`shop_goods` WRITE;
DELETE FROM `drinkshop`.`shop_goods`;
INSERT INTO `drinkshop`.`shop_goods` (`id`,`goods_category_name`,`name`,`display_order`,`default_price`,`is_sell`,`image`,`description`) VALUES (18, '小吃熟食', '支付测试', 0, 10, 1, 'goodsImage-18.jpg', '测试支付'),(19, '新鲜果茶', '百香双重奏', 1, 1400, 1, 'goodsImage-19.jpg', ''),(20, '新鲜果茶', '杨枝甘露', 2, 1700, 1, 'goodsImage-20.jpg', ''),(21, '新鲜果茶', '芝士葡萄', 3, 1900, 1, 'goodsImage-21.jpg', ''),(22, '新鲜果茶', '蜂蜜柚子茶', 4, 1300, 1, 'goodsImage-22.jpg', ''),(23, '新鲜果茶', '茉香柠檬茶', 5, 1200, 1, 'goodsImage-23.jpg', ''),(25, '风味奶茶', '润土烤奶', 1, 1500, 1, 'goodsImage-25.jpg', ''),(26, '风味奶茶', '芋圆烤奶', 2, 1500, 1, 'goodsImage-26.jpg', ''),(27, '风味奶茶', '芋圆血糯米', 3, 1300, 1, 'goodsImage-27.jpg', ''),(28, '风味奶茶', '招牌奶茶', 4, 1200, 1, 'goodsImage-28.jpg', ''),(29, '风味奶茶', '布丁奶茶', 5, 1300, 1, 'goodsImage-29.jpg', ''),(30, '风味奶茶', '椰果奶茶', 6, 1100, 1, 'goodsImage-30.jpg', ''),(31, '风味奶茶', '珍珠奶茶', 7, 1100, 1, 'goodsImage-31.jpg', ''),(33, '可可抹茶', '芝士可可', 5, 1500, 1, 'goodsImage-33.jpg', ''),(34, '可可抹茶', '醇奶抹茶', 10, 1300, 1, 'goodsImage-34.jpg?random=3063', ''),(35, '可可抹茶', '超满足抹茶', 15, 1700, 1, 'goodsImage-35.jpg?random=9828?random=1998', ''),(36, '可可抹茶', '阿华田抹茶拿铁', 25, 1900, 1, 'goodsImage-36.jpg', ''),(37, '可可抹茶', '阿华田可可拿铁', 30, 1900, 1, 'goodsImage-37.jpg', ''),(38, '牛乳茶', '奥利奥奶茶', 1, 1600, 1, 'goodsImage-38.jpg?random=7899', ''),(39, '牛乳茶', '奶芙牛乳茶', 10, 1600, 1, 'goodsImage-39.jpg', ''),(40, '牛乳茶', '布丁芋奶露', 30, 1300, 1, 'goodsImage-40.jpg', ''),(42, '纯享鲜茶', '芝士茉莉', 10, 1300, 1, 'goodsImage-42.jpg', ''),(43, '纯享鲜茶', '锦上乌龙', 20, 1100, 1, 'goodsImage-43.jpg', ''),(44, '纯享鲜茶', '芝士乌龙', 30, 1400, 1, 'goodsImage-44.jpg', ''),(45, '现磨咖啡', '焦糖玛奇朵', 10, 2300, 1, 'goodsImage-45.jpg', ''),(46, '现磨咖啡', '拿铁咖啡', 20, 1900, 1, 'goodsImage-46.jpg', ''),(47, '现磨咖啡', '摩卡咖啡', 30, 2300, 1, 'goodsImage-47.jpg', ''),(48, '现磨咖啡', '卡布奇诺', 40, 2100, 1, 'goodsImage-48.jpg', ''),(49, '现磨咖啡', '美式咖啡', 60, 1700, 1, 'goodsImage-49.jpg', ''),(50, '小吃熟食', '鸡柳', 10, 400, 1, 'goodsImage-50.jpg?random=9799', ''),(51, '小吃熟食', '骨肉相连', 20, 400, 1, 'goodsImage-51.jpg?random=1113', ''),(52, '小吃熟食', '鸡米花', 40, 1100, 1, 'goodsImage-52.jpg?random=8268', ''),(53, '小吃熟食', '脆皮鸡', 30, 1100, 1, 'goodsImage-53.jpg?random=160', ''),(54, '小吃熟食', '大薯条', 50, 1100, 1, 'goodsImage-54.jpg?random=8288', ''),(55, '小吃熟食', '鸡块', 70, 1300, 1, 'goodsImage-55.jpg?random=7954?random=1010', ''),(56, '小吃熟食', '洋葱圈', 80, 1100, 1, 'goodsImage-56.jpg?random=7659', ''),(57, '爆款推荐', '蜂蜜柚子茶', 10, 1300, 1, 'goodsImage-57.jpg', ''),(59, '爆款推荐', '招牌奶茶', 40, 1200, 1, 'goodsImage-59.jpg', ''),(60, '爆款推荐', '茉香柠檬茶', 30, 1200, 1, 'goodsImage-60.jpg', ''),(61, '爆款推荐', '芝士葡萄', 50, 1900, 1, 'goodsImage-61.jpg', ''),(62, '爆款推荐', '草莓粉桃酪酪', 60, 1800, 0, 'goodsImage-62.jpg', ''),(63, '爆款推荐', '奶芙牛乳茶', 70, 1600, 1, 'goodsImage-63.jpg', ''),(64, '爆款推荐', '桃之夭夭', 80, 1900, 0, 'goodsImage-64.jpg', ''),(66, '爆款推荐', '杨枝甘露', 100, 1700, 1, 'goodsImage-66.jpg', ''),(67, '可可抹茶', '超满足可可', 0, 1600, 1, 'goodsImage-67.jpg', ''),(68, '小吃熟食', '双人套餐一', 90, 3300, 1, 'goodsImage-68.jpg', '鸡块1份+鸡米花1份+洋葱圈1份+骨肉相连2串'),(69, '小吃熟食', '双人套餐二', 100, 3300, 1, 'goodsImage-69.jpg', '鸡锁骨1份+薯条1份+洋葱圈1份+骨肉相连2串'),(70, '小吃熟食', '单人套餐一', 110, 1700, 1, 'goodsImage-70.jpg', '鸡块半份+鸡米花半份+洋葱圈半份+骨肉相连1串'),(71, '小吃熟食', '单人套餐二', 120, 1700, 1, 'goodsImage-71.jpg', '鸡锁骨半份+薯条半份+洋葱圈半份+骨肉相连1串');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `drinkshop`.`shop_goods_category` WRITE;
DELETE FROM `drinkshop`.`shop_goods_category`;
INSERT INTO `drinkshop`.`shop_goods_category` (`name`,`display_order`,`show_status`) VALUES ('可可抹茶', 30, 1),('小吃熟食', 70, 1),('新鲜果茶', 10, 1),('爆款推荐AAAA', 5, 1),('牛乳茶', 40, 1),('现磨咖啡', 60, 1),('纯享鲜茶', 50, 1),('风味奶茶', 20, 1);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `drinkshop`.`shop_goods_property` WRITE;
DELETE FROM `drinkshop`.`shop_goods_property`;
INSERT INTO `drinkshop`.`shop_goods_property` (`id`,`goods_id`,`category`,`property_option`,`is_default`,`rebase_price`,`extra_price`) VALUES (1708, 19, '大小', '大', 1, 1400, 0),(1709, 19, '大小', '中', 0, 1200, 0),(1710, 19, '甜度', '无糖', 1, NULL, 0),(1711, 19, '甜度', '微糖', 0, NULL, 0),(1712, 19, '甜度', '半糖', 0, NULL, 0),(1713, 19, '甜度', '少糖', 0, NULL, 0),(1714, 19, '甜度', '正常甜', 0, NULL, 0),(1715, 19, '甜度', '全糖', 0, NULL, 0),(1718, 19, '温度', '冰', 1, NULL, 0),(1719, 19, '温度', '少冰', 0, NULL, 0),(1720, 19, '温度', '去冰', 0, NULL, 0),(1721, 19, '加料', '布丁', 0, NULL, 200),(1722, 19, '加料', '红豆', 0, NULL, 200),(1723, 19, '加料', '珍珠', 0, NULL, 200),(1724, 19, '加料', '西米', 0, NULL, 200),(1725, 19, '加料', '椰果', 0, NULL, 200),(1726, 19, '加料', '青稞', 0, NULL, 200),(1727, 19, '加料', '芋圆', 0, NULL, 200),(1728, 19, '加料', '血糯米', 0, NULL, 200),(1730, 20, '大小', '中', 1, 1700, 0),(1731, 20, '甜度', '无糖', 1, NULL, 0),(1732, 20, '甜度', '微糖', 0, NULL, 0),(1733, 20, '甜度', '半糖', 0, NULL, 0),(1734, 20, '甜度', '少糖', 0, NULL, 0),(1735, 20, '甜度', '正常甜', 0, NULL, 0),(1736, 20, '甜度', '全糖', 0, NULL, 0),(1739, 20, '温度', '冰', 1, NULL, 0),(1742, 20, '加料', '布丁', 0, NULL, 200),(1743, 20, '加料', '红豆', 0, NULL, 200),(1744, 20, '加料', '珍珠', 0, NULL, 200),(1745, 20, '加料', '西米', 0, NULL, 200),(1746, 20, '加料', '椰果', 0, NULL, 200),(1747, 20, '加料', '青稞', 0, NULL, 200),(1748, 20, '加料', '芋圆', 0, NULL, 200),(1749, 20, '加料', '血糯米', 0, NULL, 200),(1750, 21, '大小', '大', 1, 1900, 0),(1752, 21, '甜度', '无糖', 1, NULL, 0),(1753, 21, '甜度', '微糖', 0, NULL, 0),(1754, 21, '甜度', '半糖', 0, NULL, 0),(1755, 21, '甜度', '少糖', 0, NULL, 0),(1756, 21, '甜度', '正常甜', 0, NULL, 0),(1757, 21, '甜度', '全糖', 0, NULL, 0),(1760, 21, '温度', '冰', 1, NULL, 0),(1763, 21, '加料', '布丁', 0, NULL, 200),(1764, 21, '加料', '红豆', 0, NULL, 200),(1765, 21, '加料', '珍珠', 0, NULL, 200),(1766, 21, '加料', '西米', 0, NULL, 200),(1767, 21, '加料', '椰果', 0, NULL, 200),(1768, 21, '加料', '青稞', 0, NULL, 200),(1769, 21, '加料', '芋圆', 0, NULL, 200),(1770, 21, '加料', '血糯米', 0, NULL, 200),(1771, 22, '大小', '大', 1, 1300, 0),(1773, 22, '甜度', '无糖', 1, NULL, 0),(1774, 22, '甜度', '微糖', 0, NULL, 0),(1775, 22, '甜度', '半糖', 0, NULL, 0),(1776, 22, '甜度', '少糖', 0, NULL, 0),(1777, 22, '甜度', '正常甜', 0, NULL, 0),(1778, 22, '甜度', '全糖', 0, NULL, 0),(1780, 22, '温度', '热', 1, NULL, 0),(1781, 22, '温度', '冰', 0, NULL, 0),(1782, 22, '温度', '少冰', 0, NULL, 0),(1783, 22, '温度', '去冰', 0, NULL, 0),(1784, 22, '加料', '布丁', 0, NULL, 200),(1785, 22, '加料', '红豆', 0, NULL, 200),(1786, 22, '加料', '珍珠', 0, NULL, 200),(1787, 22, '加料', '西米', 0, NULL, 200),(1788, 22, '加料', '椰果', 0, NULL, 200),(1789, 22, '加料', '青稞', 0, NULL, 200),(1790, 22, '加料', '芋圆', 0, NULL, 200),(1791, 22, '加料', '血糯米', 0, NULL, 200),(1792, 23, '大小', '大', 1, 1200, 0),(1794, 23, '甜度', '无糖', 1, NULL, 0),(1795, 23, '甜度', '微糖', 0, NULL, 0),(1796, 23, '甜度', '半糖', 0, NULL, 0),(1797, 23, '甜度', '少糖', 0, NULL, 0),(1798, 23, '甜度', '正常甜', 0, NULL, 0),(1799, 23, '甜度', '全糖', 0, NULL, 0),(1802, 23, '温度', '冰', 1, NULL, 0),(1803, 23, '温度', '少冰', 0, NULL, 0),(1804, 23, '温度', '去冰', 0, NULL, 0),(1805, 23, '加料', '布丁', 0, NULL, 200),(1806, 23, '加料', '红豆', 0, NULL, 200),(1807, 23, '加料', '珍珠', 0, NULL, 200),(1808, 23, '加料', '西米', 0, NULL, 200),(1809, 23, '加料', '椰果', 0, NULL, 200),(1810, 23, '加料', '青稞', 0, NULL, 200),(1811, 23, '加料', '芋圆', 0, NULL, 200),(1812, 23, '加料', '血糯米', 0, NULL, 200),(1813, 24, '大小', '大', 1, 1700, 0),(1815, 24, '甜度', '无糖', 1, NULL, 0),(1816, 24, '甜度', '微糖', 0, NULL, 0),(1817, 24, '甜度', '半糖', 0, NULL, 0),(1818, 24, '甜度', '少糖', 0, NULL, 0),(1819, 24, '甜度', '正常甜', 0, NULL, 0),(1820, 24, '甜度', '全糖', 0, NULL, 0),(1822, 24, '温度', '热', 0, NULL, 0),(1823, 24, '温度', '冰', 1, NULL, 0),(1824, 24, '温度', '少冰', 0, NULL, 0),(1825, 24, '温度', '去冰', 0, NULL, 0),(1826, 24, '加料', '布丁', 0, NULL, 200),(1827, 24, '加料', '红豆', 0, NULL, 200),(1828, 24, '加料', '珍珠', 0, NULL, 200),(1829, 24, '加料', '西米', 0, NULL, 200),(1830, 24, '加料', '椰果', 0, NULL, 200),(1831, 24, '加料', '青稞', 0, NULL, 200),(1832, 24, '加料', '芋圆', 0, NULL, 200),(1833, 24, '加料', '血糯米', 0, NULL, 200),(1834, 25, '大小', '大', 1, 1500, 0),(1835, 25, '大小', '中', 0, 1300, 0),(1836, 25, '甜度', '无糖', 1, NULL, 0),(1837, 25, '甜度', '微糖', 0, NULL, 0),(1838, 25, '甜度', '半糖', 0, NULL, 0),(1839, 25, '甜度', '少糖', 0, NULL, 0),(1840, 25, '甜度', '正常甜', 0, NULL, 0),(1841, 25, '甜度', '全糖', 0, NULL, 0),(1842, 25, '温度', '常温', 1, NULL, 0),(1843, 25, '温度', '热', 0, NULL, 0),(1844, 25, '温度', '冰', 0, NULL, 0),(1845, 25, '温度', '少冰', 0, NULL, 0),(1846, 25, '温度', '去冰', 0, NULL, 0),(1847, 25, '加料', '布丁', 0, NULL, 200),(1848, 25, '加料', '红豆', 0, NULL, 200),(1849, 25, '加料', '珍珠', 0, NULL, 200),(1850, 25, '加料', '西米', 0, NULL, 200),(1851, 25, '加料', '椰果', 0, NULL, 200),(1852, 25, '加料', '青稞', 0, NULL, 200),(1853, 25, '加料', '芋圆', 0, NULL, 200),(1854, 25, '加料', '血糯米', 0, NULL, 200),(1855, 26, '大小', '大', 1, 1500, 0),(1856, 26, '大小', '中', 0, 1300, 0),(1857, 26, '甜度', '无糖', 1, NULL, 0),(1858, 26, '甜度', '微糖', 0, NULL, 0),(1859, 26, '甜度', '半糖', 0, NULL, 0),(1860, 26, '甜度', '少糖', 0, NULL, 0),(1861, 26, '甜度', '正常甜', 0, NULL, 0),(1862, 26, '甜度', '全糖', 0, NULL, 0),(1863, 26, '温度', '常温', 1, NULL, 0),(1864, 26, '温度', '热', 0, NULL, 0),(1865, 26, '温度', '冰', 0, NULL, 0),(1866, 26, '温度', '少冰', 0, NULL, 0),(1867, 26, '温度', '去冰', 0, NULL, 0),(1868, 26, '加料', '布丁', 0, NULL, 200),(1869, 26, '加料', '红豆', 0, NULL, 200),(1870, 26, '加料', '珍珠', 0, NULL, 200),(1871, 26, '加料', '西米', 0, NULL, 200),(1872, 26, '加料', '椰果', 0, NULL, 200),(1873, 26, '加料', '青稞', 0, NULL, 200),(1874, 26, '加料', '芋圆', 0, NULL, 200),(1875, 26, '加料', '血糯米', 0, NULL, 200),(1876, 27, '大小', '大', 1, 1300, 0),(1877, 27, '大小', '中', 0, 1100, 0),(1878, 27, '甜度', '无糖', 1, NULL, 0),(1879, 27, '甜度', '微糖', 0, NULL, 0),(1880, 27, '甜度', '半糖', 0, NULL, 0),(1881, 27, '甜度', '少糖', 0, NULL, 0),(1882, 27, '甜度', '正常甜', 0, NULL, 0),(1883, 27, '甜度', '全糖', 0, NULL, 0),(1884, 27, '温度', '常温', 1, NULL, 0),(1885, 27, '温度', '热', 0, NULL, 0),(1886, 27, '温度', '冰', 0, NULL, 0),(1887, 27, '温度', '少冰', 0, NULL, 0),(1888, 27, '温度', '去冰', 0, NULL, 0),(1889, 27, '加料', '布丁', 0, NULL, 200),(1890, 27, '加料', '红豆', 0, NULL, 200),(1891, 27, '加料', '珍珠', 0, NULL, 200),(1892, 27, '加料', '西米', 0, NULL, 200),(1893, 27, '加料', '椰果', 0, NULL, 200),(1894, 27, '加料', '青稞', 0, NULL, 200),(1895, 27, '加料', '芋圆', 0, NULL, 200),(1896, 27, '加料', '血糯米', 0, NULL, 200),(1897, 28, '大小', '大', 1, 1200, 0),(1898, 28, '大小', '中', 0, 1000, 0),(1899, 28, '甜度', '无糖', 1, NULL, 0),(1900, 28, '甜度', '微糖', 0, NULL, 0),(1901, 28, '甜度', '半糖', 0, NULL, 0),(1902, 28, '甜度', '少糖', 0, NULL, 0),(1903, 28, '甜度', '正常甜', 0, NULL, 0),(1904, 28, '甜度', '全糖', 0, NULL, 0),(1905, 28, '温度', '常温', 1, NULL, 0),(1906, 28, '温度', '热', 0, NULL, 0),(1907, 28, '温度', '冰', 0, NULL, 0),(1908, 28, '温度', '少冰', 0, NULL, 0),(1909, 28, '温度', '去冰', 0, NULL, 0),(1910, 28, '加料', '布丁', 0, NULL, 200),(1911, 28, '加料', '红豆', 0, NULL, 200),(1912, 28, '加料', '珍珠', 0, NULL, 200),(1913, 28, '加料', '西米', 0, NULL, 200),(1914, 28, '加料', '椰果', 0, NULL, 200),(1915, 28, '加料', '青稞', 0, NULL, 200),(1916, 28, '加料', '芋圆', 0, NULL, 200),(1917, 28, '加料', '血糯米', 0, NULL, 200),(1918, 29, '大小', '大', 1, 1300, 0),(1919, 29, '大小', '中', 0, 1100, 0),(1920, 29, '甜度', '无糖', 1, NULL, 0),(1921, 29, '甜度', '微糖', 0, NULL, 0),(1922, 29, '甜度', '半糖', 0, NULL, 0),(1923, 29, '甜度', '少糖', 0, NULL, 0),(1924, 29, '甜度', '正常甜', 0, NULL, 0),(1925, 29, '甜度', '全糖', 0, NULL, 0),(1926, 29, '温度', '常温', 1, NULL, 0),(1927, 29, '温度', '热', 0, NULL, 0),(1928, 29, '温度', '冰', 0, NULL, 0),(1929, 29, '温度', '少冰', 0, NULL, 0),(1930, 29, '温度', '去冰', 0, NULL, 0),(1931, 29, '加料', '布丁', 0, NULL, 200),(1932, 29, '加料', '红豆', 0, NULL, 200),(1933, 29, '加料', '珍珠', 0, NULL, 200),(1934, 29, '加料', '西米', 0, NULL, 200),(1935, 29, '加料', '椰果', 0, NULL, 200),(1936, 29, '加料', '青稞', 0, NULL, 200),(1937, 29, '加料', '芋圆', 0, NULL, 200),(1938, 29, '加料', '血糯米', 0, NULL, 200),(1939, 30, '大小', '大', 1, 1100, 0),(1940, 30, '大小', '中', 0, 900, 0),(1941, 30, '甜度', '无糖', 1, NULL, 0),(1942, 30, '甜度', '微糖', 0, NULL, 0),(1943, 30, '甜度', '半糖', 0, NULL, 0),(1944, 30, '甜度', '少糖', 0, NULL, 0),(1945, 30, '甜度', '正常甜', 0, NULL, 0),(1946, 30, '甜度', '全糖', 0, NULL, 0),(1947, 30, '温度', '常温', 1, NULL, 0),(1948, 30, '温度', '热', 0, NULL, 0),(1949, 30, '温度', '冰', 0, NULL, 0),(1950, 30, '温度', '少冰', 0, NULL, 0),(1951, 30, '温度', '去冰', 0, NULL, 0),(1952, 30, '加料', '布丁', 0, NULL, 200),(1953, 30, '加料', '红豆', 0, NULL, 200),(1954, 30, '加料', '珍珠', 0, NULL, 200),(1955, 30, '加料', '西米', 0, NULL, 200),(1956, 30, '加料', '椰果', 0, NULL, 200),(1957, 30, '加料', '青稞', 0, NULL, 200),(1958, 30, '加料', '芋圆', 0, NULL, 200),(1959, 30, '加料', '血糯米', 0, NULL, 200),(1960, 31, '大小', '大', 1, 1100, 0),(1961, 31, '大小', '中', 0, 900, 0),(1962, 31, '甜度', '无糖', 1, NULL, 0),(1963, 31, '甜度', '微糖', 0, NULL, 0),(1964, 31, '甜度', '半糖', 0, NULL, 0),(1965, 31, '甜度', '少糖', 0, NULL, 0),(1966, 31, '甜度', '正常甜', 0, NULL, 0),(1967, 31, '甜度', '全糖', 0, NULL, 0),(1968, 31, '温度', '常温', 1, NULL, 0),(1969, 31, '温度', '热', 0, NULL, 0),(1970, 31, '温度', '冰', 0, NULL, 0),(1971, 31, '温度', '少冰', 0, NULL, 0),(1972, 31, '温度', '去冰', 0, NULL, 0),(1973, 31, '加料', '布丁', 0, NULL, 200),(1974, 31, '加料', '红豆', 0, NULL, 200),(1975, 31, '加料', '珍珠', 0, NULL, 200),(1976, 31, '加料', '西米', 0, NULL, 200),(1977, 31, '加料', '椰果', 0, NULL, 200),(1978, 31, '加料', '青稞', 0, NULL, 200),(1979, 31, '加料', '芋圆', 0, NULL, 200),(1980, 31, '加料', '血糯米', 0, NULL, 200),(1982, 32, '大小', '中', 1, 1500, 0),(1983, 32, '甜度', '无糖', 0, NULL, 0),(1984, 32, '甜度', '微糖', 0, NULL, 0),(1985, 32, '甜度', '半糖', 0, NULL, 0),(1986, 32, '甜度', '少糖', 0, NULL, 0),(1987, 32, '甜度', '正常甜', 1, NULL, 0),(1988, 32, '甜度', '全糖', 0, NULL, 0),(1989, 32, '温度', '常温', 1, NULL, 0),(1990, 32, '温度', '热', 0, NULL, 0),(1991, 32, '温度', '冰', 0, NULL, 0),(1992, 32, '温度', '少冰', 0, NULL, 0),(1993, 32, '温度', '去冰', 0, NULL, 0),(1994, 32, '加料', '布丁', 0, NULL, 200),(1995, 32, '加料', '红豆', 0, NULL, 200),(1996, 32, '加料', '珍珠', 0, NULL, 200),(1997, 32, '加料', '西米', 0, NULL, 200),(1998, 32, '加料', '椰果', 0, NULL, 200),(1999, 32, '加料', '青稞', 0, NULL, 200),(2000, 32, '加料', '芋圆', 0, NULL, 200),(2001, 32, '加料', '血糯米', 0, NULL, 200),(2003, 33, '大小', '中', 1, 1500, 0),(2004, 33, '甜度', '无糖', 0, NULL, 0),(2005, 33, '甜度', '微糖', 0, NULL, 0),(2006, 33, '甜度', '半糖', 1, NULL, 0),(2007, 33, '甜度', '少糖', 0, NULL, 0),(2008, 33, '甜度', '正常甜', 0, NULL, 0),(2009, 33, '甜度', '全糖', 0, NULL, 0),(2010, 33, '温度', '常温', 1, NULL, 0),(2011, 33, '温度', '热', 0, NULL, 0),(2012, 33, '温度', '冰', 0, NULL, 0),(2013, 33, '温度', '少冰', 0, NULL, 0),(2014, 33, '温度', '去冰', 0, NULL, 0),(2015, 33, '加料', '布丁', 0, NULL, 200),(2016, 33, '加料', '红豆', 0, NULL, 200),(2017, 33, '加料', '珍珠', 0, NULL, 200),(2018, 33, '加料', '西米', 0, NULL, 200),(2019, 33, '加料', '椰果', 0, NULL, 200),(2020, 33, '加料', '青稞', 0, NULL, 200),(2021, 33, '加料', '芋圆', 0, NULL, 200),(2022, 33, '加料', '血糯米', 0, NULL, 200),(2024, 34, '大小', '中', 1, 1300, 0),(2025, 34, '甜度', '无糖', 0, NULL, 0),(2026, 34, '甜度', '微糖', 0, NULL, 0),(2027, 34, '甜度', '半糖', 0, NULL, 0),(2028, 34, '甜度', '少糖', 0, NULL, 0),(2029, 34, '甜度', '正常甜', 1, NULL, 0),(2030, 34, '甜度', '全糖', 0, NULL, 0),(2031, 34, '温度', '常温', 1, NULL, 0),(2032, 34, '温度', '热', 0, NULL, 0),(2033, 34, '温度', '冰', 0, NULL, 0),(2034, 34, '温度', '少冰', 0, NULL, 0),(2035, 34, '温度', '去冰', 0, NULL, 0),(2036, 34, '加料', '布丁', 0, NULL, 200),(2037, 34, '加料', '红豆', 0, NULL, 200),(2038, 34, '加料', '珍珠', 0, NULL, 200),(2039, 34, '加料', '西米', 0, NULL, 200),(2040, 34, '加料', '椰果', 0, NULL, 200),(2041, 34, '加料', '青稞', 0, NULL, 200),(2042, 34, '加料', '芋圆', 0, NULL, 200),(2043, 34, '加料', '血糯米', 0, NULL, 200),(2044, 35, '大小', '大', 1, 1700, 0),(2046, 35, '甜度', '无糖', 0, NULL, 0),(2047, 35, '甜度', '微糖', 0, NULL, 0),(2048, 35, '甜度', '半糖', 0, NULL, 0),(2049, 35, '甜度', '少糖', 0, NULL, 0),(2050, 35, '甜度', '正常甜', 1, NULL, 0),(2051, 35, '甜度', '全糖', 0, NULL, 0),(2052, 35, '温度', '常温', 1, NULL, 0),(2053, 35, '温度', '热', 0, NULL, 0),(2054, 35, '温度', '冰', 0, NULL, 0),(2055, 35, '温度', '少冰', 0, NULL, 0),(2056, 35, '温度', '去冰', 0, NULL, 0),(2057, 35, '加料', '布丁', 0, NULL, 200),(2058, 35, '加料', '红豆', 0, NULL, 200),(2059, 35, '加料', '珍珠', 0, NULL, 200),(2060, 35, '加料', '西米', 0, NULL, 200),(2061, 35, '加料', '椰果', 0, NULL, 200),(2062, 35, '加料', '青稞', 0, NULL, 200),(2063, 35, '加料', '芋圆', 0, NULL, 200),(2064, 35, '加料', '血糯米', 0, NULL, 200),(2066, 36, '大小', '中', 1, 1900, 0),(2067, 36, '甜度', '无糖', 0, NULL, 0),(2068, 36, '甜度', '微糖', 0, NULL, 0),(2069, 36, '甜度', '半糖', 0, NULL, 0),(2070, 36, '甜度', '少糖', 0, NULL, 0),(2071, 36, '甜度', '正常甜', 1, NULL, 0),(2072, 36, '甜度', '全糖', 0, NULL, 0),(2073, 36, '温度', '常温', 1, NULL, 0),(2074, 36, '温度', '热', 0, NULL, 0),(2075, 36, '温度', '冰', 0, NULL, 0),(2076, 36, '温度', '少冰', 0, NULL, 0),(2077, 36, '温度', '去冰', 0, NULL, 0),(2078, 36, '加料', '布丁', 0, NULL, 200),(2079, 36, '加料', '红豆', 0, NULL, 200),(2080, 36, '加料', '珍珠', 0, NULL, 200),(2081, 36, '加料', '西米', 0, NULL, 200),(2082, 36, '加料', '椰果', 0, NULL, 200),(2083, 36, '加料', '青稞', 0, NULL, 200),(2084, 36, '加料', '芋圆', 0, NULL, 200),(2085, 36, '加料', '血糯米', 0, NULL, 200),(2087, 37, '大小', '中', 1, 1900, 0),(2088, 37, '甜度', '无糖', 0, NULL, 0),(2089, 37, '甜度', '微糖', 0, NULL, 0),(2090, 37, '甜度', '半糖', 0, NULL, 0),(2091, 37, '甜度', '少糖', 0, NULL, 0),(2092, 37, '甜度', '正常甜', 1, NULL, 0),(2093, 37, '甜度', '全糖', 0, NULL, 0),(2094, 37, '温度', '常温', 1, NULL, 0),(2095, 37, '温度', '热', 0, NULL, 0),(2096, 37, '温度', '冰', 0, NULL, 0),(2097, 37, '温度', '少冰', 0, NULL, 0),(2098, 37, '温度', '去冰', 0, NULL, 0),(2099, 37, '加料', '布丁', 0, NULL, 200),(2100, 37, '加料', '红豆', 0, NULL, 200),(2101, 37, '加料', '珍珠', 0, NULL, 200),(2102, 37, '加料', '西米', 0, NULL, 200),(2103, 37, '加料', '椰果', 0, NULL, 200),(2104, 37, '加料', '青稞', 0, NULL, 200),(2105, 37, '加料', '芋圆', 0, NULL, 200),(2106, 37, '加料', '血糯米', 0, NULL, 200),(2108, 38, '大小', '中', 1, 1600, 0),(2109, 38, '甜度', '无糖', 1, NULL, 0),(2110, 38, '甜度', '微糖', 0, NULL, 0),(2111, 38, '甜度', '半糖', 0, NULL, 0),(2112, 38, '甜度', '少糖', 0, NULL, 0),(2113, 38, '甜度', '正常甜', 0, NULL, 0),(2114, 38, '甜度', '全糖', 0, NULL, 0),(2115, 38, '温度', '常温', 1, NULL, 0),(2116, 38, '温度', '热', 0, NULL, 0),(2117, 38, '温度', '冰', 0, NULL, 0),(2118, 38, '温度', '少冰', 0, NULL, 0),(2119, 38, '温度', '去冰', 0, NULL, 0),(2120, 38, '加料', '布丁', 0, NULL, 200),(2121, 38, '加料', '红豆', 0, NULL, 200),(2122, 38, '加料', '珍珠', 0, NULL, 200),(2123, 38, '加料', '西米', 0, NULL, 200),(2124, 38, '加料', '椰果', 0, NULL, 200),(2125, 38, '加料', '青稞', 0, NULL, 200),(2126, 38, '加料', '芋圆', 0, NULL, 200),(2127, 38, '加料', '血糯米', 0, NULL, 200),(2129, 39, '大小', '中', 1, 1600, 0),(2130, 39, '甜度', '无糖', 1, NULL, 0),(2131, 39, '甜度', '微糖', 0, NULL, 0),(2132, 39, '甜度', '半糖', 0, NULL, 0),(2133, 39, '甜度', '少糖', 0, NULL, 0),(2134, 39, '甜度', '正常甜', 0, NULL, 0),(2135, 39, '甜度', '全糖', 0, NULL, 0),(2136, 39, '温度', '常温', 1, NULL, 0),(2137, 39, '温度', '热', 0, NULL, 0),(2138, 39, '温度', '冰', 0, NULL, 0),(2139, 39, '温度', '少冰', 0, NULL, 0),(2140, 39, '温度', '去冰', 0, NULL, 0),(2141, 39, '加料', '布丁', 0, NULL, 200),(2142, 39, '加料', '红豆', 0, NULL, 200),(2143, 39, '加料', '珍珠', 0, NULL, 200),(2144, 39, '加料', '西米', 0, NULL, 200),(2145, 39, '加料', '椰果', 0, NULL, 200),(2146, 39, '加料', '青稞', 0, NULL, 200),(2147, 39, '加料', '芋圆', 0, NULL, 200),(2148, 39, '加料', '血糯米', 0, NULL, 200),(2149, 40, '大小', '大', 1, 1300, 0),(2150, 40, '大小', '中', 0, 1100, 0),(2151, 40, '甜度', '无糖', 1, NULL, 0),(2152, 40, '甜度', '微糖', 0, NULL, 0),(2153, 40, '甜度', '半糖', 0, NULL, 0),(2154, 40, '甜度', '少糖', 0, NULL, 0),(2155, 40, '甜度', '正常甜', 0, NULL, 0),(2156, 40, '甜度', '全糖', 0, NULL, 0),(2157, 40, '温度', '常温', 1, NULL, 0),(2158, 40, '温度', '热', 0, NULL, 0),(2159, 40, '温度', '冰', 0, NULL, 0),(2160, 40, '温度', '少冰', 0, NULL, 0),(2161, 40, '温度', '去冰', 0, NULL, 0),(2162, 40, '加料', '布丁', 0, NULL, 200),(2163, 40, '加料', '红豆', 0, NULL, 200),(2164, 40, '加料', '珍珠', 0, NULL, 200),(2165, 40, '加料', '西米', 0, NULL, 200),(2166, 40, '加料', '椰果', 0, NULL, 200),(2167, 40, '加料', '青稞', 0, NULL, 200),(2168, 40, '加料', '芋圆', 0, NULL, 200),(2169, 40, '加料', '血糯米', 0, NULL, 200),(2170, 41, '大小', '大', 1, 2000, 0),(2171, 41, '大小', '中', 0, 1700, 0),(2172, 41, '甜度', '无糖', 1, NULL, 0),(2173, 41, '甜度', '微糖', 0, NULL, 0),(2174, 41, '甜度', '半糖', 0, NULL, 0),(2175, 41, '甜度', '少糖', 0, NULL, 0),(2176, 41, '甜度', '正常甜', 0, NULL, 0),(2177, 41, '甜度', '全糖', 0, NULL, 0),(2178, 41, '温度', '常温', 1, NULL, 0),(2179, 41, '温度', '热', 0, NULL, 0),(2180, 41, '温度', '冰', 0, NULL, 0),(2181, 41, '温度', '少冰', 0, NULL, 0),(2182, 41, '温度', '去冰', 0, NULL, 0),(2183, 41, '加料', '布丁', 0, NULL, 200),(2184, 41, '加料', '红豆', 0, NULL, 200),(2185, 41, '加料', '珍珠', 0, NULL, 200),(2186, 41, '加料', '西米', 0, NULL, 200),(2187, 41, '加料', '椰果', 0, NULL, 200),(2188, 41, '加料', '青稞', 0, NULL, 200),(2189, 41, '加料', '芋圆', 0, NULL, 200),(2190, 41, '加料', '血糯米', 0, NULL, 200),(2191, 42, '大小', '大', 0, 1500, 0),(2192, 42, '大小', '中', 1, 1300, 0),(2193, 42, '甜度', '无糖', 1, NULL, 0),(2194, 42, '甜度', '微糖', 0, NULL, 0),(2195, 42, '甜度', '半糖', 0, NULL, 0),(2196, 42, '甜度', '少糖', 0, NULL, 0),(2197, 42, '甜度', '正常甜', 0, NULL, 0),(2198, 42, '甜度', '全糖', 0, NULL, 0),(2201, 42, '温度', '冰', 1, NULL, 0),(2202, 42, '温度', '少冰', 0, NULL, 0),(2203, 42, '温度', '去冰', 0, NULL, 0),(2204, 42, '加料', '布丁', 0, NULL, 200),(2205, 42, '加料', '红豆', 0, NULL, 200),(2206, 42, '加料', '珍珠', 0, NULL, 200),(2207, 42, '加料', '西米', 0, NULL, 200),(2208, 42, '加料', '椰果', 0, NULL, 200),(2209, 42, '加料', '青稞', 0, NULL, 200),(2210, 42, '加料', '芋圆', 0, NULL, 200),(2211, 42, '加料', '血糯米', 0, NULL, 200),(2212, 43, '大小', '大', 1, 1100, 0),(2214, 43, '甜度', '无糖', 1, NULL, 0),(2215, 43, '甜度', '微糖', 0, NULL, 0),(2216, 43, '甜度', '半糖', 0, NULL, 0),(2217, 43, '甜度', '少糖', 0, NULL, 0),(2218, 43, '甜度', '正常甜', 0, NULL, 0),(2219, 43, '甜度', '全糖', 0, NULL, 0),(2220, 43, '温度', '常温', 1, NULL, 0),(2221, 43, '温度', '热', 0, NULL, 0),(2222, 43, '温度', '冰', 0, NULL, 0),(2223, 43, '温度', '少冰', 0, NULL, 0),(2224, 43, '温度', '去冰', 0, NULL, 0),(2225, 43, '加料', '布丁', 0, NULL, 200),(2226, 43, '加料', '红豆', 0, NULL, 200),(2227, 43, '加料', '珍珠', 0, NULL, 200),(2228, 43, '加料', '西米', 0, NULL, 200),(2229, 43, '加料', '椰果', 0, NULL, 200),(2230, 43, '加料', '青稞', 0, NULL, 200),(2231, 43, '加料', '芋圆', 0, NULL, 200),(2232, 43, '加料', '血糯米', 0, NULL, 200),(2233, 44, '大小', '大', 1, 1400, 0),(2234, 44, '大小', '中', 0, 1200, 0),(2235, 44, '甜度', '无糖', 1, NULL, 0),(2236, 44, '甜度', '微糖', 0, NULL, 0),(2237, 44, '甜度', '半糖', 0, NULL, 0),(2238, 44, '甜度', '少糖', 0, NULL, 0),(2239, 44, '甜度', '正常甜', 0, NULL, 0),(2240, 44, '甜度', '全糖', 0, NULL, 0),(2241, 44, '温度', '常温', 1, NULL, 0),(2242, 44, '温度', '热', 0, NULL, 0),(2243, 44, '温度', '冰', 0, NULL, 0),(2244, 44, '温度', '少冰', 0, NULL, 0),(2245, 44, '温度', '去冰', 0, NULL, 0),(2246, 44, '加料', '布丁', 0, NULL, 200),(2247, 44, '加料', '红豆', 0, NULL, 200),(2248, 44, '加料', '珍珠', 0, NULL, 200),(2249, 44, '加料', '西米', 0, NULL, 200),(2250, 44, '加料', '椰果', 0, NULL, 200),(2251, 44, '加料', '青稞', 0, NULL, 200),(2252, 44, '加料', '芋圆', 0, NULL, 200),(2253, 44, '加料', '血糯米', 0, NULL, 200),(2255, 45, '大小', '中', 1, 2300, 0),(2263, 45, '温度', '热', 1, NULL, 0),(2264, 45, '温度', '冰', 0, NULL, 0),(2276, 46, '大小', '中', 1, 1900, 0),(2284, 46, '温度', '热', 1, NULL, 0),(2285, 46, '温度', '冰', 0, NULL, 0),(2288, 46, '加料', '布丁', 0, NULL, 200),(2289, 46, '加料', '红豆', 0, NULL, 200),(2290, 46, '加料', '珍珠', 0, NULL, 200),(2291, 46, '加料', '西米', 0, NULL, 200),(2292, 46, '加料', '椰果', 0, NULL, 200),(2293, 46, '加料', '青稞', 0, NULL, 200),(2294, 46, '加料', '芋圆', 0, NULL, 200),(2295, 46, '加料', '血糯米', 0, NULL, 200),(2297, 47, '大小', '中', 1, 2300, 0),(2305, 47, '温度', '热', 1, NULL, 0),(2306, 47, '温度', '冰', 0, NULL, 0),(2309, 47, '加料', '布丁', 0, NULL, 200),(2310, 47, '加料', '红豆', 0, NULL, 200),(2311, 47, '加料', '珍珠', 0, NULL, 200),(2312, 47, '加料', '西米', 0, NULL, 200),(2313, 47, '加料', '椰果', 0, NULL, 200),(2314, 47, '加料', '青稞', 0, NULL, 200),(2315, 47, '加料', '芋圆', 0, NULL, 200),(2316, 47, '加料', '血糯米', 0, NULL, 200),(2318, 48, '大小', '中', 1, 2100, 0),(2326, 48, '温度', '热', 1, NULL, 0),(2327, 48, '温度', '冰', 0, NULL, 0),(2330, 48, '加料', '布丁', 0, NULL, 200),(2331, 48, '加料', '红豆', 0, NULL, 200),(2332, 48, '加料', '珍珠', 0, NULL, 200),(2333, 48, '加料', '西米', 0, NULL, 200),(2334, 48, '加料', '椰果', 0, NULL, 200),(2335, 48, '加料', '青稞', 0, NULL, 200),(2336, 48, '加料', '芋圆', 0, NULL, 200),(2337, 48, '加料', '血糯米', 0, NULL, 200),(2339, 49, '大小', '中', 1, 1700, 0),(2347, 49, '温度', '热', 1, NULL, 0),(2348, 49, '温度', '冰', 0, NULL, 0),(2351, 49, '加料', '布丁', 0, NULL, 200),(2352, 49, '加料', '红豆', 0, NULL, 200),(2353, 49, '加料', '珍珠', 0, NULL, 200),(2354, 49, '加料', '西米', 0, NULL, 200),(2355, 49, '加料', '椰果', 0, NULL, 200),(2356, 49, '加料', '青稞', 0, NULL, 200),(2357, 49, '加料', '芋圆', 0, NULL, 200),(2358, 49, '加料', '血糯米', 0, NULL, 200),(2506, 57, '大小', '大', 1, 1300, 0),(2508, 57, '甜度', '无糖', 1, NULL, 0),(2509, 57, '甜度', '微糖', 0, NULL, 0),(2510, 57, '甜度', '半糖', 0, NULL, 0),(2511, 57, '甜度', '少糖', 0, NULL, 0),(2512, 57, '甜度', '正常甜', 0, NULL, 0),(2513, 57, '甜度', '全糖', 0, NULL, 0),(2514, 57, '温度', '常温', 1, NULL, 0),(2515, 57, '温度', '热', 0, NULL, 0),(2516, 57, '温度', '冰', 0, NULL, 0),(2517, 57, '温度', '少冰', 0, NULL, 0),(2518, 57, '温度', '去冰', 0, NULL, 0),(2519, 57, '加料', '布丁', 0, NULL, 200),(2520, 57, '加料', '红豆', 0, NULL, 200),(2521, 57, '加料', '珍珠', 0, NULL, 200),(2522, 57, '加料', '西米', 0, NULL, 200),(2523, 57, '加料', '椰果', 0, NULL, 200),(2524, 57, '加料', '青稞', 0, NULL, 200),(2525, 57, '加料', '芋圆', 0, NULL, 200),(2526, 57, '加料', '血糯米', 0, NULL, 200),(2527, 58, '大小', '大', 1, 2000, 0),(2529, 58, '甜度', '无糖', 1, NULL, 0),(2530, 58, '甜度', '微糖', 0, NULL, 0),(2531, 58, '甜度', '半糖', 0, NULL, 0),(2532, 58, '甜度', '少糖', 0, NULL, 0),(2533, 58, '甜度', '正常甜', 0, NULL, 0),(2534, 58, '甜度', '全糖', 0, NULL, 0),(2536, 58, '温度', '热', 1, NULL, 0),(2537, 58, '温度', '冰', 0, NULL, 0),(2538, 58, '温度', '少冰', 0, NULL, 0),(2539, 58, '温度', '去冰', 0, NULL, 0),(2540, 58, '加料', '布丁', 0, NULL, 200),(2541, 58, '加料', '红豆', 0, NULL, 200),(2542, 58, '加料', '珍珠', 0, NULL, 200),(2543, 58, '加料', '西米', 0, NULL, 200),(2544, 58, '加料', '椰果', 0, NULL, 200),(2545, 58, '加料', '青稞', 0, NULL, 200),(2546, 58, '加料', '芋圆', 0, NULL, 200),(2547, 58, '加料', '血糯米', 0, NULL, 200),(2548, 59, '大小', '大', 1, 1200, 0),(2549, 59, '大小', '中', 0, 1000, 0),(2550, 59, '甜度', '无糖', 1, NULL, 0),(2551, 59, '甜度', '微糖', 0, NULL, 0),(2552, 59, '甜度', '半糖', 0, NULL, 0),(2553, 59, '甜度', '少糖', 0, NULL, 0),(2554, 59, '甜度', '正常甜', 0, NULL, 0),(2555, 59, '甜度', '全糖', 0, NULL, 0),(2556, 59, '温度', '常温', 1, NULL, 0),(2557, 59, '温度', '热', 0, NULL, 0),(2558, 59, '温度', '冰', 0, NULL, 0),(2559, 59, '温度', '少冰', 0, NULL, 0),(2560, 59, '温度', '去冰', 0, NULL, 0),(2561, 59, '加料', '布丁', 0, NULL, 200),(2562, 59, '加料', '红豆', 0, NULL, 200),(2563, 59, '加料', '珍珠', 0, NULL, 200),(2564, 59, '加料', '西米', 0, NULL, 200),(2565, 59, '加料', '椰果', 0, NULL, 200),(2566, 59, '加料', '青稞', 0, NULL, 200),(2567, 59, '加料', '芋圆', 0, NULL, 200),(2568, 59, '加料', '血糯米', 0, NULL, 200),(2569, 60, '大小', '大', 1, 1200, 0),(2571, 60, '甜度', '无糖', 1, NULL, 0),(2572, 60, '甜度', '微糖', 0, NULL, 0),(2573, 60, '甜度', '半糖', 0, NULL, 0),(2574, 60, '甜度', '少糖', 0, NULL, 0),(2575, 60, '甜度', '正常甜', 0, NULL, 0),(2576, 60, '甜度', '全糖', 0, NULL, 0),(2579, 60, '温度', '冰', 1, NULL, 0),(2580, 60, '温度', '少冰', 0, NULL, 0),(2581, 60, '温度', '去冰', 0, NULL, 0),(2582, 60, '加料', '布丁', 0, NULL, 200),(2583, 60, '加料', '红豆', 0, NULL, 200),(2584, 60, '加料', '珍珠', 0, NULL, 200),(2585, 60, '加料', '西米', 0, NULL, 200),(2586, 60, '加料', '椰果', 0, NULL, 200),(2587, 60, '加料', '青稞', 0, NULL, 200),(2588, 60, '加料', '芋圆', 0, NULL, 200),(2589, 60, '加料', '血糯米', 0, NULL, 200),(2590, 61, '大小', '大', 1, 1900, 0),(2592, 61, '甜度', '无糖', 1, NULL, 0),(2593, 61, '甜度', '微糖', 0, NULL, 0),(2594, 61, '甜度', '半糖', 0, NULL, 0),(2595, 61, '甜度', '少糖', 0, NULL, 0),(2596, 61, '甜度', '正常甜', 0, NULL, 0),(2597, 61, '甜度', '全糖', 0, NULL, 0),(2600, 61, '温度', '冰', 1, NULL, 0),(2603, 61, '加料', '布丁', 0, NULL, 200),(2604, 61, '加料', '红豆', 0, NULL, 200),(2605, 61, '加料', '珍珠', 0, NULL, 200),(2606, 61, '加料', '西米', 0, NULL, 200),(2607, 61, '加料', '椰果', 0, NULL, 200),(2608, 61, '加料', '青稞', 0, NULL, 200),(2609, 61, '加料', '芋圆', 0, NULL, 200),(2610, 61, '加料', '血糯米', 0, NULL, 200),(2611, 62, '大小', '大', 1, 1800, 0),(2613, 62, '甜度', '无糖', 1, NULL, 0),(2614, 62, '甜度', '微糖', 0, NULL, 0),(2615, 62, '甜度', '半糖', 0, NULL, 0),(2616, 62, '甜度', '少糖', 0, NULL, 0),(2617, 62, '甜度', '正常甜', 0, NULL, 0),(2618, 62, '甜度', '全糖', 0, NULL, 0),(2621, 62, '温度', '冰', 1, NULL, 0),(2624, 62, '加料', '布丁', 0, NULL, 200),(2625, 62, '加料', '红豆', 0, NULL, 200),(2626, 62, '加料', '珍珠', 0, NULL, 200),(2627, 62, '加料', '西米', 0, NULL, 200),(2628, 62, '加料', '椰果', 0, NULL, 200),(2629, 62, '加料', '青稞', 0, NULL, 200),(2630, 62, '加料', '芋圆', 0, NULL, 200),(2631, 62, '加料', '血糯米', 0, NULL, 200),(2633, 63, '大小', '中', 1, 1600, 0),(2634, 63, '甜度', '无糖', 1, NULL, 0),(2635, 63, '甜度', '微糖', 0, NULL, 0),(2636, 63, '甜度', '半糖', 0, NULL, 0),(2637, 63, '甜度', '少糖', 0, NULL, 0),(2638, 63, '甜度', '正常甜', 0, NULL, 0),(2639, 63, '甜度', '全糖', 0, NULL, 0),(2640, 63, '温度', '常温', 1, NULL, 0),(2641, 63, '温度', '热', 0, NULL, 0),(2642, 63, '温度', '冰', 0, NULL, 0),(2643, 63, '温度', '少冰', 0, NULL, 0),(2644, 63, '温度', '去冰', 0, NULL, 0),(2645, 63, '加料', '布丁', 0, NULL, 200),(2646, 63, '加料', '红豆', 0, NULL, 200),(2647, 63, '加料', '珍珠', 0, NULL, 200),(2648, 63, '加料', '西米', 0, NULL, 200),(2649, 63, '加料', '椰果', 0, NULL, 200),(2650, 63, '加料', '青稞', 0, NULL, 200),(2651, 63, '加料', '芋圆', 0, NULL, 200),(2652, 63, '加料', '血糯米', 0, NULL, 200),(2654, 64, '大小', '中', 1, 1900, 0),(2655, 64, '甜度', '无糖', 1, NULL, 0),(2656, 64, '甜度', '微糖', 0, NULL, 0),(2657, 64, '甜度', '半糖', 0, NULL, 0),(2658, 64, '甜度', '少糖', 0, NULL, 0),(2659, 64, '甜度', '正常甜', 0, NULL, 0),(2660, 64, '甜度', '全糖', 0, NULL, 0),(2663, 64, '温度', '冰', 1, NULL, 0),(2666, 64, '加料', '布丁', 0, NULL, 200),(2667, 64, '加料', '红豆', 0, NULL, 200),(2668, 64, '加料', '珍珠', 0, NULL, 200),(2669, 64, '加料', '西米', 0, NULL, 200),(2670, 64, '加料', '椰果', 0, NULL, 200),(2671, 64, '加料', '青稞', 0, NULL, 200),(2672, 64, '加料', '芋圆', 0, NULL, 200),(2673, 64, '加料', '血糯米', 0, NULL, 200),(2674, 65, '大小', '大', 1, 1700, 0),(2676, 65, '甜度', '无糖', 1, NULL, 0),(2677, 65, '甜度', '微糖', 0, NULL, 0),(2678, 65, '甜度', '半糖', 0, NULL, 0),(2679, 65, '甜度', '少糖', 0, NULL, 0),(2680, 65, '甜度', '正常甜', 0, NULL, 0),(2681, 65, '甜度', '全糖', 0, NULL, 0),(2682, 65, '温度', '常温', 1, NULL, 0),(2683, 65, '温度', '热', 0, NULL, 0),(2684, 65, '温度', '冰', 0, NULL, 0),(2685, 65, '温度', '少冰', 0, NULL, 0),(2686, 65, '温度', '去冰', 0, NULL, 0),(2687, 65, '加料', '布丁', 0, NULL, 200),(2688, 65, '加料', '红豆', 0, NULL, 200),(2689, 65, '加料', '珍珠', 0, NULL, 200),(2690, 65, '加料', '西米', 0, NULL, 200),(2691, 65, '加料', '椰果', 0, NULL, 200),(2692, 65, '加料', '青稞', 0, NULL, 200),(2693, 65, '加料', '芋圆', 0, NULL, 200),(2694, 65, '加料', '血糯米', 0, NULL, 200),(2696, 66, '大小', '中', 1, 1700, 0),(2697, 66, '甜度', '无糖', 1, NULL, 0),(2698, 66, '甜度', '微糖', 0, NULL, 0),(2699, 66, '甜度', '半糖', 0, NULL, 0),(2700, 66, '甜度', '少糖', 0, NULL, 0),(2701, 66, '甜度', '正常甜', 0, NULL, 0),(2702, 66, '甜度', '全糖', 0, NULL, 0),(2705, 66, '温度', '冰', 1, NULL, 0),(2708, 66, '加料', '布丁', 0, NULL, 200),(2709, 66, '加料', '红豆', 0, NULL, 200),(2710, 66, '加料', '珍珠', 0, NULL, 200),(2711, 66, '加料', '西米', 0, NULL, 200),(2712, 66, '加料', '椰果', 0, NULL, 200),(2713, 66, '加料', '青稞', 0, NULL, 200),(2714, 66, '加料', '芋圆', 0, NULL, 200),(2715, 66, '加料', '血糯米', 0, NULL, 200),(2717, 67, '大小', '大杯', 1, 1600, 0),(2718, 67, '温度', '温热', 1, 0, 0),(2719, 67, '温度', '冰', 0, 0, 0),(2720, 67, '温度', '去冰', 0, 0, 0),(2721, 67, '甜度', '无糖', 0, 0, 0),(2722, 67, '温度', '微糖', 0, 0, 0),(2723, 67, '甜度', '半糖', 0, 0, 0),(2724, 67, '甜度', '少糖', 0, 0, 0),(2725, 67, '甜度', '正常甜', 1, 0, 0),(2726, 67, '甜度', '全糖', 0, 0, 0);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `drinkshop`.`shop_home` WRITE;
DELETE FROM `drinkshop`.`shop_home`;
INSERT INTO `drinkshop`.`shop_home` (`id`,`type_id`,`img`,`product_id`,`sort`) VALUES (1, 1, '/profile/upload/2024/11/08/lunbo1_20241108000146A001.jpg', 1, 1),(2, 1, '/profile/upload/2024/11/08/lunbo2_20241108000157A002.jpg', 2, 2),(3, 1, '/profile/upload/2024/11/08/lunbo3_20241108000211A003.jpg', 3, 3);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `drinkshop`.`shop_order_info` WRITE;
DELETE FROM `drinkshop`.`shop_order_info`;
INSERT INTO `drinkshop`.`shop_order_info` (`order_no`,`wx_openid`,`order_status`,`payjs_order_id`,`wx_pay_transaction_id`,`take_type`,`address_detail`,`goods_preview`,`goods_total_num`,`total_price`,`pay_price`,`verify_num`,`extra_info`,`create_time`,`pay_time`,`finish_time`,`user_phone`,`receiver`) VALUES ('202104120219-1009', 'oxci95aic29pnvZnVJboqWV8aLdA', '已完成', NULL, '4200000988202104183889816796', '外卖配送', '园林新村24栋', '奥利奥奶茶[常温 中 布丁 半糖 ]*1,单人套餐二*1', 2, 3500, 3500, 7172, '', '2021-04-18 12:02:19', '2021-04-18 12:02:25', '2021-04-18 13:35:40', '18981717172', '李泽'),('202104120221-1072', 'oxci95WP3PlnpXZJ3JoVHtvWVu9w', '已完成', NULL, '4200001033202104281876715423', '外卖配送', '3区23舍a511', '芋圆血糯米[少冰 中 正常甜 ]*1', 1, 1100, 1100, 7774, '', '2021-04-28 12:02:21', '2021-04-28 12:02:26', '2021-08-22 22:17:47', '18784117774', '孙一鸣'),('202104120321-1010', 'oxci95cWduDK9F83DAPDrlrZLE6c', '已完成', NULL, '4200000986202104187211350379', '外卖配送', '2区10舍512', '芋圆血糯米[少冰 大 少糖 ]*1,布丁奶茶[少冰 大 少糖 ]*1,芋圆血糯米[常温 大 微糖 ]*1', 3, 3900, 3900, 8163, '', '2021-04-18 12:03:22', '2021-04-18 12:03:26', '2021-04-18 22:03:16', '15700308163', '杨'),('202104120410-1011', 'oxci95YGj97N0mum_9Dl4Inw3XJk', '已完成', NULL, '4200000985202104183698688105', '外卖配送', '三区19舍B304', '醇奶抹茶[热 中 红豆 珍珠 正常甜 ]*1', 1, 1600, 1600, 142, '19舍   B304 请放门口', '2021-04-18 12:04:11', '2021-04-18 12:04:20', '2021-04-18 23:00:50', '18384990142', 'Jojo'),('202104120957-1073', 'oxci95cTWJ18z1uoZxrHO1I51FVQ', '已完成', NULL, '4200001044202104285162539657', '外卖配送', '3区23舍A709', '招牌奶茶[热 大 西米 无糖 ]*1', 1, 1400, 1400, 2350, '', '2021-04-28 12:09:58', '2021-04-28 12:10:01', '2021-05-18 21:11:38', '18375982350', '赖鑫'),('202104122130-1062', 'oxci95TIO1GKLMig-RZo6i2lfDfo', '已完成', NULL, '4200001030202104277001213318', '外卖配送', '13舍404', '草莓粉桃酪酪[冰 大 半糖 ]*1', 1, 1800, 1800, 9371, '', '2021-04-27 12:21:31', '2021-04-27 12:21:35', '2021-04-28 10:57:15', '15222149371', '王茗雪'),('202104123314-1002', 'oxci95YADfp4S1EHX6loh0oRav9I', '已完成', NULL, '4200000982202104195868552893', '外卖配送', '2区10舍512', '芋圆血糯米[少冰 大 少糖 ]*2', 2, 2600, 2600, 8163, '', '2021-04-19 12:33:14', '2021-04-19 12:33:20', '2021-04-19 14:57:01', '15700308163', '吴'),('202104123611-1027', 'oxci95W6GG4GG3ubZyYxZIfbriYg', '已完成', NULL, '4200000995202104231666739998', '外卖配送', '3区18舍null', '阿华田抹茶拿铁[少冰 中 正常甜 ]*1', 1, 1900, 1900, 6389, '18舍A106门口谢谢', '2021-04-23 12:36:12', '2021-04-23 12:36:17', '2021-04-23 12:39:24', '18942896389', '周麟'),('202104124543-1004', 'oxci95YADfp4S1EHX6loh0oRav9I', '已完成', NULL, '4200000992202104179647338928', '外卖配送', '2区10舍512', '芋圆血糯米[去冰 大 少糖 ]*1,芝士抹茶[常温 中 正常甜 ]*1,芋圆血糯米[常温 大 微糖 ]*1', 3, 4100, 4100, 8163, '', '2021-04-17 12:45:59', '2021-04-17 12:45:58', '2021-04-17 12:50:05', '15700308163', '吴'),('202104130834-1001', 'oxci95QiFQ6V_p3Pr5frTig2eOT4', '已完成', NULL, '4200000995202104067715978712', '外卖配送', '2区17舍201', '珍珠奶茶[热 中杯 正常 ]*2', 2, 1700, 1700, 7282, '', '2021-04-06 13:08:44', '2021-04-06 13:08:44', '2021-04-06 13:14:17', '18383507282', '李飞'),('202104133029-1051', 'oxci95UO6x4A29oQ3S532dHXCJqU', '已完成', NULL, '4200000941202104250186249700', '外卖配送', '2区16舍513', '芝士葡萄[冰 大 正常甜 ]*1', 1, 1900, 1900, 2523, '', '2021-04-25 13:30:30', '2021-04-25 13:30:34', '2021-04-25 13:38:14', '19934042523', '刘宇轩'),('202104133731-1074', 'oxci95T33arJk3K286qIbX6zzvM0', '已完成', NULL, '4200001036202104280935261411', '外卖配送', '3区23舍A301', '招牌奶茶[去冰 大 椰果 正常甜 ]*1', 1, 1400, 1400, 5204, '', '2021-04-28 13:37:32', '2021-04-28 13:37:37', '2021-04-28 13:39:53', '17321915204', '陈先生'),('202104135116-1005', 'oxci95QiFQ6V_p3Pr5frTig2eOT4', '已完成', NULL, '4200000986202104064182052078', '外卖配送', '2区17舍201', '血糯米奶茶[加冰 大杯 少量糖 ]*1', 1, 1400, 1400, 7282, '', '2021-04-06 13:51:23', '2021-04-06 13:51:23', NULL, '18383507282', '李飞'),('202104135640-1063', 'oxci95SS_ZR5Izm0ynv9ZXP8cvag', '已完成', NULL, '4200001039202104277821940515', '外卖配送', '2区12舍202', '单人套餐二*1,珍珠奶茶[热 大 微糖 ]*1', 2, 2800, 2800, 1496, '', '2021-04-27 13:56:41', '2021-04-27 13:56:45', '2021-04-27 13:57:44', '13981921496', '高清晨'),('202104144547-1013', 'oxci95aPNSMvmZEB1H9WY5O2lIjI', '已完成', NULL, '4200000992202104181921983332', '外卖配送', '2区10舍711', '润土烤奶[常温 大 正常甜 ]*1', 1, 1500, 1500, 7782, '2区10舍711，18996127782', '2021-04-18 14:45:47', '2021-04-18 14:45:52', '2021-04-19 14:56:59', '18996127782', '周越遨'),('202104144555-1028', 'oxci95VeGK-Q5ixx3j8c6sVC5DcE', '已完成', NULL, '4200000939202104232987633440', '外卖配送', '7舍401', '超满足抹茶[冰 大 正常甜 ]*2', 2, 3200, 3200, 1049, '', '2021-04-23 14:45:56', '2021-04-23 14:46:00', '2021-04-23 14:47:57', '15983501049', '佘罗晨'),('202104145247-1029', 'oxci95QFOF3Jg6AuoDLb1tzNtg9s', '已完成', NULL, '4200001046202104237212681766', '外卖配送', '3区21舍a208', '蜂蜜柚子茶[冰 大 正常甜 ]*1', 1, 1300, 1300, 2931, '', '2021-04-23 14:52:48', '2021-04-23 14:52:52', '2021-04-23 14:55:32', '17321912931', '黄瑞'),('202104145744-1020', 'oxci95boyv_THgPhEWtK2LM8obKo', '已完成', NULL, '4200000984202104227824615835', '外卖配送', '16舍302', '百香双重奏[少冰 大 少糖 ]*1', 1, 1400, 1400, 615, '', '2021-04-22 14:57:44', '2021-04-22 14:57:49', '2021-04-22 14:59:35', '17399640615', '韦奕豪'),('202104150224-1003', 'oxci95XeGQ2xBs36SibYO9gCBbdQ', '已完成', NULL, '4200000983202104202192298177', '外卖配送', '四政113', '蜂蜜柚子茶[去冰 大 全糖 ]*1', 1, 1300, 1300, 7577, '', '2021-04-20 15:02:25', '2021-04-20 15:02:30', '2021-04-20 15:05:16', '13084167577', '石成越'),('202104150546-1045', 'oxci95bF-BCcWosF6P3DrzyeAgIk', '已完成', NULL, '4200000944202104243736288309', '外卖配送', '2区16舍201', '芝士葡萄[冰 大 半糖 ]*1', 1, 1900, 1900, 3227, '糖度正常即可', '2021-04-24 15:05:46', '2021-04-24 15:05:51', '2021-04-24 15:49:23', '18820763227', '林思浩'),('202104151031-1058', 'oxci95WiwHJ32PhGEY5VXTu7wW1s', '已完成', NULL, '4200001033202104269085624378', '外卖配送', '2区14舍407', '招牌奶茶[热 中 芋圆 半糖 ]*1', 1, 1200, 1200, 2583, '', '2021-04-26 15:10:31', '2021-04-26 15:10:37', '2021-04-26 15:20:04', '18095052583', '李'),('202104152052-1052', 'oxci95UXD9SKpyg4Rk38Tr4gnRMk', '已完成', NULL, '4200000993202104254322781022', '外卖配送', '16舍504', '杨枝甘露[冰 中 全糖 ]*1,芝士葡萄[冰 大 正常甜 ]*1,芝士葡萄[冰 大 无糖 ]*1,大薯条*1', 4, 6600, 6600, 4930, '都少冰', '2021-04-25 15:20:53', '2021-04-25 15:20:57', '2021-04-25 15:27:26', '15259814930', '饶健坤'),('202104152602-1030', 'oxci95QFOF3Jg6AuoDLb1tzNtg9s', '已完成', NULL, '4200000998202104239830675842', '外卖配送', '3区21舍a208', '芝士乌龙[冰 大 全糖 ]*1', 1, 1400, 1400, 2931, '', '2021-04-23 15:26:02', '2021-04-23 15:26:07', '2021-04-23 15:27:18', '17321912931', '黄瑞'),('202104152726-1031', 'oxci95bWpyv--0uzm4I6a-i6_0k4', '已完成', NULL, '4200001030202104234089664465', '外卖配送', '3区18舍A204', '芝士葡萄[冰 大 少糖 ]*1', 1, 1900, 1900, 2487, ' 请放门口', '2021-04-23 15:27:27', '2021-04-23 15:27:32', '2021-04-23 15:29:42', '19942372487', '冯颖'),('202104153009-1046', 'oxci95ckprIyYx6zSWp8An8XFKv8', '已完成', NULL, '4200000990202104245716720258', '外卖配送', '2区14舍409', '桃之夭夭[冰 中 血糯米 正常甜 ]*1', 1, 2100, 2100, 2906, '少冰哈', '2021-04-24 15:30:09', '2021-04-24 15:30:15', '2021-04-24 15:50:56', '15182632906', '曾月亭'),('202104160126-1004', 'oxci95TIO1GKLMig-RZo6i2lfDfo', '已完成', NULL, '4200000999202104200023922664', '外卖配送', '13舍404', '百香双重奏[少冰 大 无糖 ]*1', 1, 1400, 1400, 9371, '', '2021-04-20 16:01:26', '2021-04-20 16:01:31', '2021-04-20 16:43:06', '15222149371', '王茗雪'),('202104161904-1003', 'oxci95U3KGSQkPVcymOhvP3z4jhY', '已完成', NULL, '4200000989202104088552924812', '外卖配送', '10舍408', '黄金乌龙[大杯 ]*1,烤椰子蛋糕奶*1', 2, 1600, 1600, 4185, '', '2021-04-08 16:19:08', '2021-04-08 16:19:08', NULL, '17774644185', '郑宇'),('202104162653-1075', 'oxci95b1MARB7RaPCs_TA-Ke6EJ8', '已完成', NULL, '4200001034202104289479608517', '外卖配送', '3区23舍null', '招牌奶茶[去冰 中 椰果 少糖 ]*1', 1, 1200, 1200, 5092, '3区23舍A301  18398705092', '2021-04-28 16:26:54', '2021-04-28 16:27:04', '2021-08-22 22:17:45', '18398705092', '范祥'),('202104162858-1065', 'oxci95Yj2iYWj7P--2C_UBpzA2oU', '已完成', NULL, '4200001037202104277816545905', '外卖配送', '2区13舍608', '奶芙牛乳茶[冰 中 珍珠 正常甜 ]*1,阿华田抹茶拿铁[冰 中 正常甜 ]*1,奥利奥奶茶[冰 中 布丁 正常甜 ]*1', 3, 5500, 5500, 4337, '', '2021-04-27 16:28:58', '2021-04-27 16:29:44', '2021-04-27 16:31:53', '18808214337', '叶思怡'),('202104163043-1066', 'oxci95SmBtrxtMKMsTZf3qAcztPQ', '已完成', NULL, '4200001042202104270146089714', '外卖配送', '1区7舍503', '超满足可可[冰 大杯 正常甜 ]*1', 1, 1600, 1600, 4510, '', '2021-04-27 16:30:43', '2021-04-27 16:30:47', '2021-04-27 16:32:26', '17390434510', '张凯棋'),('202104165214-1021', 'oxci95dRcUHvFMXX0XGj-vMIeUO8', '已完成', NULL, '4200000946202104229510876536', '外卖配送', '濆江园林新村14栋（12教生科院背后）', '超满足抹茶[热 大 正常甜 ]*1', 1, 1600, 1600, 9705, '', '2021-04-22 16:52:14', '2021-04-22 16:52:18', '2021-04-22 16:55:13', '18064989705', '七七'),('202104165807-1005', 'oxci95b8WQgpuIFon0L9nlml2-gY', '已完成', NULL, '4200000993202104177949010577', '外卖配送', '3区18舍B413', '布丁芋奶露[常温 大 西米 芋圆 血糯米 无糖 ]*1', 1, 1900, 1900, 4103, '请送餐上寝，谢谢', '2021-04-17 16:58:07', '2021-04-17 16:58:11', '2021-04-17 17:49:38', '15808154103', '随安而遇'),('202104171210-1047', 'oxci95SCN1_xrTA_bg60vwKUJosE', '已完成', NULL, '4200000993202104245908315509', '外卖配送', '2区11舍519', '布丁芋奶露[少冰 大 微糖 ]*1', 1, 1300, 1300, 3360, '', '2021-04-24 17:12:11', '2021-04-24 17:12:17', '2021-04-26 14:04:56', '17746753360', '符'),('202104171849-1059', 'oxci95UO6x4A29oQ3S532dHXCJqU', '已完成', NULL, '4200001047202104264744190265', '外卖配送', '2区16舍513', '芋圆烤奶[常温 大 正常甜 ]*1', 1, 1500, 1500, 2523, '', '2021-04-26 17:18:49', '2021-04-26 17:18:55', '2021-04-26 20:29:50', '19934042523', '刘宇轩'),('202104172846-1068', 'oxci95Ui8iDhyr68sPI06W6Yrdso', '已完成', NULL, '4200001035202104273993855108', '外卖配送', '2区17舍708', '珍珠奶茶[冰 大 正常甜 ]*1', 1, 1100, 1100, 9563, '', '2021-04-27 17:28:47', '2021-04-27 17:28:54', '2021-04-27 17:30:39', '17883189563', '陈'),('202104174734-1006', 'oxci95X-BVoeToTdO3iXSW8RUkSM', '已完成', NULL, '4200000945202104177008408050', '外卖配送', '2区16舍314', '超满足可可[去冰 大杯 正常甜 ]*1,单人套餐一*1', 2, 3300, 3300, 3696, '', '2021-04-17 17:47:34', '2021-04-17 17:47:40', '2021-04-17 19:47:33', '15928023696', '陈畅'),('202104174856-1022', 'oxci95YADfp4S1EHX6loh0oRav9I', '已完成', NULL, '4200000998202104228698752610', '外卖配送', '2区10舍512', '蜂蜜柚子茶[少冰 大 无糖 ]*1', 1, 1300, 1300, 8163, '', '2021-04-22 17:48:56', '2021-04-22 17:49:11', '2021-04-22 17:50:52', '15700308163', '吴'),('202104175451-1007', 'oxci95YGj97N0mum_9Dl4Inw3XJk', '已完成', NULL, '4200000990202104171773274828', '外卖配送', '三区19舍B304', '奶芙牛乳茶[常温 中 正常甜 ]*1', 1, 1600, 1600, 142, '', '2021-04-17 17:54:51', '2021-04-17 17:54:58', '2021-04-17 19:47:36', '18384990142', 'Jojo'),('202104180901-1069', 'oxci95UO6x4A29oQ3S532dHXCJqU', '已完成', NULL, '4200001034202104279317855368', '外卖配送', '2区16舍513', '芝士乌龙[常温 大 正常甜 ]*1', 1, 1400, 1400, 2523, '', '2021-04-27 18:09:01', '2021-04-27 18:09:06', '2021-04-27 18:10:26', '19934042523', '刘宇轩'),('202104181129-1006', 'oxci95YgEYlioZJAFIaiM9DVTm5A', '已完成', NULL, '4200000989202104162658415397', '外卖配送', '老区5舍530', '杨枝甘露[冰 中 西米 全糖 ]*1', 1, 1900, 1900, 6107, '', '2021-04-16 18:11:33', '2021-04-16 18:11:33', '2021-04-16 18:51:48', '13369496107', '王立博'),('202104181223-1048', 'oxci95T33arJk3K286qIbX6zzvM0', '已完成', NULL, '4200000998202104243033863229', '外卖配送', '3区23舍A301', '招牌奶茶[去冰 大 无糖 ]*1', 1, 1200, 1200, 5204, '', '2021-04-24 18:12:23', '2021-04-24 18:12:29', '2021-04-28 13:37:57', '17321915204', '陈先生'),('202104181347-1011', 'oxci95X_jymzjREewaZeQOPjfglE', '已完成', NULL, '4200000997202104091193610806', '外卖配送', '3区宿舍23舍B307', '茉莉奶绿[大杯 ]*1,奥利奥奶茶*1', 2, 2300, 2300, 2281, ' 要温的', '2021-04-09 18:13:52', '2021-04-09 18:13:52', NULL, '17358982281', '王'),('202104182042-1032', 'oxci95boyv_THgPhEWtK2LM8obKo', '已完成', NULL, '4200001044202104233432490286', '外卖配送', '19舍B305', '珍珠奶茶[常温 大 芋圆 微糖 ]*1', 1, 1300, 1300, 615, '', '2021-04-23 18:20:43', '2021-04-23 18:20:47', '2021-04-23 18:27:29', '17399640615', '潘俊卓'),('202104182227-1033', 'oxci95boyv_THgPhEWtK2LM8obKo', '已完成', NULL, '4200000944202104239458421525', '外卖配送', '19舍B309', '珍珠奶茶[热 大 红豆 半糖 ]*1', 1, 1300, 1300, 615, '', '2021-04-23 18:22:28', '2021-04-23 18:22:32', '2021-04-23 18:27:25', '17399640615', '张丽榕'),('202104183211-1053', 'oxci95TIO1GKLMig-RZo6i2lfDfo', '已完成', NULL, '4200000991202104251590521508', '外卖配送', '13舍404', '草莓粉桃酪酪[冰 大 微糖 ]*1', 1, 1800, 1800, 9371, '', '2021-04-25 18:32:11', '2021-04-25 18:32:18', '2021-04-25 18:47:04', '15222149371', '王茗雪'),('202104183916-1007', 'oxci95ezS8vhzD1nzV3W9gXMAvAU', '已完成', NULL, '4200000941202104163434454538', '外卖配送', '2区13舍719', '奶芙牛乳茶[热 中 芋圆 半糖 ]*1,奶芙牛乳茶[常温 中 正常甜 ]*1', 2, 3400, 3400, 2449, '', '2021-04-16 18:39:21', '2021-04-16 18:39:21', '2021-04-16 19:18:52', '18580962449', '何'),('202104191129-1023', 'oxci95SmBtrxtMKMsTZf3qAcztPQ', '已完成', NULL, '4200001030202104226565742602', '外卖配送', '1区7舍503', '芝士抹茶[冰 中 正常甜 ]*1', 1, 1500, 1500, 4510, '', '2021-04-22 19:11:29', '2021-04-22 19:11:33', '2021-04-22 19:13:00', '17390434510', '张凯棋'),('202104192513-1054', 'oxci95eLsgtBUy413HC5r0ZyTOPM', '已完成', NULL, '4200001035202104257821041513', '外卖配送', '18舍a606', '布丁芋奶露[热 中 布丁 珍珠 微糖 ]*1', 1, 1500, 1500, 5096, '', '2021-04-25 19:25:14', '2021-04-25 19:25:19', '2021-04-25 19:29:24', '15681605096', '小张'),('202104193429-1055', 'oxci95ac73RoSgfL3-1VJWguklQs', '已完成', NULL, '4200000992202104253829627893', '外卖配送', '2区14舍712', '招牌奶茶[热 大 半糖 ]*3', 3, 3600, 3600, 450, '', '2021-04-25 19:34:29', '2021-04-25 19:34:41', '2021-04-25 19:41:57', '18383570450', '陈向熙'),('202104193535-1034', 'oxci95QcTnDTDzf-0qUK5SnQT_bM', '已完成', NULL, '4200000939202104233588276214', '外卖配送', '2区16舍504', '布丁奶茶[常温 大 无糖 ]*1,大薯条*1', 2, 2400, 2400, 6123, '', '2021-04-23 19:35:35', '2021-04-23 19:35:41', '2021-04-23 19:38:42', '15198056123', '吴'),('202104193720-1007', 'oxci95fbLV_RxLp5ZeH3s6m2YRzA', '已完成', NULL, '4200000984202104202445632052', '外卖配送', '23舍A505', '招牌奶茶[去冰 大 正常甜 ]*1', 1, 1200, 1200, 5760, '', '2021-04-20 19:37:21', '2021-04-20 19:37:26', '2021-04-20 20:00:43', '18383575760', '刘'),('202104194317-1049', 'oxci95RXLAq8p4ALKgIdz5Bb6Jn8', '已完成', NULL, '4200001035202104249511867724', '外卖配送', '2区15舍407', '招牌奶茶[常温 大 珍珠 椰果 全糖 ]*1', 1, 1600, 1600, 7501, '', '2021-04-24 19:43:17', '2021-04-24 19:43:23', '2021-04-24 19:48:01', '19130487501', '何'),('202104194533-1008', 'oxci95X7ifKy8p_19FzwxQ5IN4m0', '已完成', NULL, '4200000999202104177976656033', '外卖配送', '3区23舍a510', '椰果奶茶[常温 大 无糖 ]*1', 1, 1100, 1100, 4842, '', '2021-04-17 19:45:34', '2021-04-17 19:45:39', '2021-04-17 19:47:38', '18308364842', '沈杰'),('202104195900-1071', 'oxci95YjVie0sLX7xhOyYgD5kH4U', '已完成', NULL, '4200001035202104274553987288', '外卖配送', '2区13舍207', '布丁芋奶露[热 中 布丁 无糖 ]*1,芝士抹茶[去冰 中 正常甜 ]*1', 2, 2800, 2800, 9967, '', '2021-04-27 19:59:00', '2021-04-27 19:59:06', '2021-04-27 20:14:01', '19112089967', '黎茂月'),('202104200032-1035', 'oxci95fbLV_RxLp5ZeH3s6m2YRzA', '已完成', NULL, '4200001047202104236499028131', '外卖配送', '23舍A505', '布丁芋奶露[去冰 大 正常甜 ]*1', 1, 1300, 1300, 5760, '', '2021-04-23 20:00:33', '2021-04-23 20:00:38', '2021-04-23 20:02:17', '18383575760', '刘'),('202104200222-1050', 'oxci95TIO1GKLMig-RZo6i2lfDfo', '已完成', NULL, '4200001030202104242092022617', '外卖配送', '13舍404', '单人套餐一*1,鸡柳*1,脆皮鸡*1', 3, 3200, 3200, 9371, '', '2021-04-24 20:02:23', '2021-04-24 20:02:35', '2021-04-24 20:04:40', '15222149371', '王茗雪'),('202104200304-1038', 'oxci95QgAE1pBSnNIwGx3Pmo_3YQ', '已完成', NULL, '4200001038202104234549585979', '外卖配送', '2区16舍504', '大薯条*1', 1, 1100, 1100, 229, '要番茄酱', '2021-04-23 20:03:04', '2021-04-23 20:03:13', '2021-04-23 20:07:43', '18208320229', '王浩然'),('202104201737-1056', 'oxci95eSPJiVR2e8twxhzoDNU1qk', '已完成', NULL, '4200000989202104255600827246', '外卖配送', '三区18舍B404', '奥利奥奶茶[常温 中 全糖 ]*1,鸡柳*1', 2, 2000, 2000, 380, '', '2021-04-25 20:17:37', '2021-04-25 20:17:43', '2021-04-25 20:20:24', '17361210380', '张珂薰'),('202104201929-1025', 'oxci95Xf4JMJuH4U-Rp3LTu-eITY', '已完成', NULL, '4200000944202104229469229970', '外卖配送', '2区14舍null', '布丁芋奶露[去冰 中 半糖 ]*1', 1, 1100, 1100, 2015, '706', '2021-04-22 20:19:30', '2021-04-22 20:19:38', '2021-04-22 20:28:07', '18141372015', '吴'),('202104202742-1040', 'oxci95eY9iJS8s6QLJi0lr4JPudY', '已完成', NULL, '4200001046202104234654772003', '外卖配送', '14舍215不能上寝请取消订单', '布丁奶茶[少冰 中 少糖 ]*1,布丁奶茶[热 中 微糖 ]*1', 2, 2200, 2200, 9027, '不能送餐上寝请取消订单', '2021-04-23 20:27:43', '2021-04-23 20:27:47', '2021-04-23 20:39:11', '17801729027', '房'),('202104204145-1041', 'oxci95cIWLD24ERFDpBL3trM-Vmg', '已完成', NULL, '4200001043202104236510646794', '外卖配送', '3区23舍A701', '茉香柠檬茶[少冰 大 无糖 ]*1', 1, 1200, 1200, 183, '不要糖不要糖不要糖，谢谢', '2021-04-23 20:41:45', '2021-04-23 20:41:50', '2021-04-23 20:44:22', '18011430183', '乔三猫'),('202104204700-1026', 'oxci95R2vySiBzSZpxxvgSbmeXMk', '已完成', NULL, '4200000980202104228231512758', '外卖配送', '2区15舍702', '草莓粉桃酪酪[冰 大 微糖 ]*1', 1, 1800, 1800, 3871, '', '2021-04-22 20:47:01', '2021-04-22 20:47:07', '2021-04-22 20:49:00', '19934043871', '朱'),('202104205252-1057', 'oxci95QFOF3Jg6AuoDLb1tzNtg9s', '已完成', NULL, '4200000983202104253030094746', '外卖配送', '3区21舍a208', '芝士茉莉[冰 大 正常甜 ]*1', 1, 1500, 1500, 2931, '', '2021-04-25 20:52:52', '2021-04-25 20:52:57', '2021-04-25 20:55:08', '17321912931', '黄瑞'),('202104210249-1017', 'oxci95TvO-yfsANPH4J93AAY_zV0', '已完成', NULL, '4200000984202104218971490335', '外卖配送', '2区14舍205', '阿华田可可拿铁[常温 中 正常甜 ]*1,大薯条*1', 2, 3000, 3000, 5665, '', '2021-04-21 21:02:50', '2021-04-21 21:02:55', '2021-04-21 21:07:06', '15283785665', '李辉'),('202104210755-1009', 'oxci95YGj97N0mum_9Dl4Inw3XJk', '已完成', NULL, '4200000999202104206730807961', '外卖配送', '三区19舍B304', '招牌奶茶[热 中 红豆 珍珠 正常甜 ]*1', 1, 1400, 1400, 142, '19舍B304', '2021-04-20 21:07:55', '2021-04-20 21:08:03', '2021-04-20 21:34:26', '18384990142', 'Jojo'),('202104211406-1018', 'oxci95X-BVoeToTdO3iXSW8RUkSM', '已完成', NULL, '4200000989202104217942629459', '外卖配送', '2区16舍314', '芋圆烤奶[去冰 大 全糖 ]*1', 1, 1500, 1500, 3696, '', '2021-04-21 21:14:07', '2021-04-21 21:14:11', '2021-04-21 21:19:14', '15928023696', '陈畅'),('202104213000-1042', 'oxci95UsyiL7uAQi6GoS-vrTCluA', '已完成', NULL, '4200000989202104235494379884', '外卖配送', '2区17舍710', '芋圆烤奶[热 大 全糖 ]*1', 1, 1500, 1500, 228, '', '2021-04-23 21:30:01', '2021-04-23 21:30:07', '2021-04-23 21:33:08', '18383550228', '杨显斌'),('202104213204-1061', 'oxci95QFOF3Jg6AuoDLb1tzNtg9s', '已完成', NULL, '4200001040202104267933204982', '外卖配送', '3区21舍a208', '芝士茉莉[冰 大 正常甜 ]*1', 1, 1500, 1500, 2931, '', '2021-04-26 21:32:05', '2021-04-26 21:32:09', '2021-04-26 21:55:21', '17321912931', '黄瑞'),('202104213236-1010', 'oxci95QIpYZkSVm2xSiy4Fg_Jd94', '已完成', NULL, '4200000991202104206716779456', '外卖配送', '2区13舍211', '奶芙牛乳茶[热 中 正常甜 ]*1', 1, 1600, 1600, 4918, '', '2021-04-20 21:32:36', '2021-04-20 21:32:43', '2021-04-23 00:06:09', '15342884918', '吕蓉芳'),('202104214351-1004', 'oxci95caUkkqoOi51ELdySiL7cVI', '已完成', NULL, '4200000987202104081520940808', '外卖配送', '二区15舍211', '热狗*1,珍珠奶茶[热 中杯 半糖 ]*1', 2, 1100, 1100, 5388, '', '2021-04-08 21:43:57', '2021-04-08 21:43:57', NULL, '18808175388', '江一丰'),('202104214451-1011', 'oxci95cZTL2adEI8KpYn8P0S5gOk', '已完成', NULL, '4200000980202104202413308212', '外卖配送', '2区17舍102', '醇奶抹茶[常温 中 正常甜 ]*1', 1, 1200, 1200, 9703, ' 要冰的', '2021-04-20 21:44:52', '2021-04-20 21:45:01', '2021-04-21 12:38:06', '15656469703', '刘冬珺'),('202104214524-1044', 'oxci95S3xNIor5U0vtua0s082bUs', '已完成', NULL, '4200000941202104230728353361', '外卖配送', '3区19舍b402', '招牌奶茶[热 中 正常甜 ]*1', 1, 1000, 1000, 926, '', '2021-04-23 21:45:24', '2021-04-23 21:45:35', '2021-04-23 21:53:04', '17300200926', '石锦源'),('202105173906-1001', 'oxci95QFOF3Jg6AuoDLb1tzNtg9s', '已完成', NULL, '4200001034202105200018573876', '外卖配送', '3区21舍a208', '蜂蜜柚子茶[冰 大 半糖 ]*1', 1, 1300, 1300, 2931, '', '2021-05-20 17:39:07', '2021-05-20 17:39:18', '2021-08-22 22:16:28', '17321912931', '黄瑞'),('202105213053-1002', 'oxci95T33arJk3K286qIbX6zzvM0', '已完成', NULL, '4200001033202105137922620986', '外卖配送', '3区23舍A301', '招牌奶茶[去冰 大 椰果 正常甜 ]*1', 1, 1400, 1400, 5204, '', '2021-05-13 21:30:54', '2021-05-13 21:30:58', '2021-08-22 22:17:44', '17321915204', '陈先生'),('202108150725-1001', 'oK3r84teJdc7oStGn_hpRc0B2FcA', '已取消', '2021082514141500576986891', NULL, '外卖配送', '2区10舍', '椰果奶茶[热 大 无糖 ]*1,珍珠奶茶[冰 大 椰果 无糖 ]*1', 2, 2400, NULL, 9046, '', '2021-08-23 15:07:25', NULL, NULL, '17058179046', '陈亚如'),('202108163157-1001', 'oK3r84teJdc7oStGn_hpRc0B2FcA', '制作中', '2021082516320000361893035', '4200001182202108254982967252', '到店自取', '到店自取', '支付测试*1', 1, 10, 10, 9046, '', '2021-08-25 16:31:57', NULL, NULL, '17058179046', '陈亚如'),('202108163515-1002', 'oK3r84teJdc7oStGn_hpRc0B2FcA', '请取餐', '2021082516373200493813338', '4200001184202108259417682975', '到店自取', '到店自取', '支付测试*1', 1, 10, 10, 9046, '', '2021-08-25 16:35:15', NULL, '2024-01-25 11:41:41', '17058179046', '陈亚如'),('202108170738-1001', 'o7LFAwavj-o4wKkEXdpA-kQmmajc', '已取消', NULL, NULL, '到店自取', '到店自取', '支付测试*1', 1, 10, NULL, 9046, '', '2021-08-25 17:07:38', NULL, NULL, '17058179046', '陈亚如'),('202108172315-1001', 'oK3r84teJdc7oStGn_hpRc0B2FcA', '未付款', NULL, NULL, '到店自取', '到店自取', '支付测试*1', 1, 10, NULL, 9046, '', '2021-08-25 17:23:15', NULL, NULL, '17058179046', '陈亚如'),('202108175802-1001', 'oK3r84teJdc7oStGn_hpRc0B2FcA', '已取消', NULL, NULL, '到店自取', '到店自取', '支付测试*1', 1, 10, 10, 9046, '', '2021-08-22 17:58:03', NULL, NULL, '17058179046', '陈亚如'),('202108181243-1001', 'oxci95SnSaCpN5NAvv66T4XYDVR8', '已取消', NULL, NULL, '外卖配送', '2区15舍309', '杨枝甘露[冰 中 无糖 ]*1', 1, 1700, 1700, 9046, '', '2021-08-22 18:12:44', NULL, NULL, '17058179046', '陈亚如'),('202108181323-1002', 'oxci95SnSaCpN5NAvv66T4XYDVR8', '已取消', NULL, NULL, '外卖配送', '2区15舍309', '杨枝甘露[冰 中 无糖 ]*1', 1, 1700, 1700, 9046, '', '2021-08-22 18:13:23', NULL, NULL, '17058179046', '陈亚如'),('202108192722-1003', 'oxci95SnSaCpN5NAvv66T4XYDVR8', '已取消', NULL, NULL, '到店自取', '到店自取', '支付测试*1', 1, 10, 10, 9046, '订单取消原因: [商家取消]', '2021-08-22 19:27:22', NULL, NULL, '17058179046', '陈亚如'),('202108192806-1004', 'oK3r84teJdc7oStGn_hpRc0B2FcA', '已完成', '2021082220255500199059612', '4200001187202108225197257181', '到店自取', '到店自取', '支付测试*1', 1, 10, 10, 9046, '', '2021-08-22 19:28:07', NULL, '2021-08-22 22:17:42', '17058179046', '陈亚如'),('202108210530-1001', 'oK3r84teJdc7oStGn_hpRc0B2FcA', '已取消', '2021082221053800371446957', NULL, '外卖配送', '2区10舍', '蜂蜜柚子茶[常温 大 无糖 ]*1', 1, 1300, NULL, 9046, '', '2021-08-22 21:05:30', NULL, NULL, '17058179046', '陈亚如'),('202108210759-1002', 'oK3r84teJdc7oStGn_hpRc0B2FcA', '已取消', NULL, NULL, '外卖配送', '2区10舍', '茉香柠檬茶[冰 大 无糖 ]*2', 2, 2400, NULL, 9046, '', '2021-08-22 21:07:59', NULL, NULL, '17058179046', '陈亚如'),('202108210913-1003', 'oK3r84teJdc7oStGn_hpRc0B2FcA', '已取消', NULL, NULL, '外卖配送', '2区10舍', '蜂蜜柚子茶[常温 大 无糖 ]*1', 1, 1300, NULL, 9046, '', '2021-08-22 21:09:14', NULL, NULL, '17058179046', '陈亚如'),('202108211037-1004', 'oK3r84teJdc7oStGn_hpRc0B2FcA', '已取消', NULL, NULL, '外卖配送', '2区10舍', '蜂蜜柚子茶[常温 大 无糖 ]*1', 1, 1300, NULL, 9046, '', '2021-08-22 21:10:37', NULL, NULL, '17058179046', '陈亚如'),('202108211123-1005', 'oK3r84teJdc7oStGn_hpRc0B2FcA', '已取消', NULL, NULL, '外卖配送', '2区10舍', '蜂蜜柚子茶[常温 大 无糖 ]*1', 1, 1300, NULL, 9046, '', '2021-08-22 21:11:24', NULL, NULL, '17058179046', '陈亚如'),('202108211203-1006', 'oK3r84teJdc7oStGn_hpRc0B2FcA', '已取消', NULL, NULL, '外卖配送', '2区10舍', '蜂蜜柚子茶[常温 大 无糖 ]*1', 1, 1300, NULL, 9046, '', '2021-08-22 21:12:04', NULL, NULL, '17058179046', '陈亚如'),('202108211615-1001', 'oK3r84teJdc7oStGn_hpRc0B2FcA', '已完成', '2021082221161900144535956', '4200001187202108227179804344', '到店自取', '到店自取', '支付测试*1', 1, 10, 10, 9046, '', '2021-08-22 21:16:16', NULL, '2021-08-22 22:17:40', '17058179046', '陈亚如'),('202108220555-1002', 'oK3r84teJdc7oStGn_hpRc0B2FcA', '已取消', '2021082222081300293015576', NULL, '外卖配送', '2区10舍', '椰果奶茶[常温 大 无糖 ]*1', 1, 1100, NULL, 9046, '', '2021-08-22 22:05:56', NULL, NULL, '17058179046', '陈亚如'),('202108221807-1003', 'oK3r84teJdc7oStGn_hpRc0B2FcA', '已取消', '2021082222181000607237773', '4200001165202108227210944399', '到店自取', '到店自取', '支付测试*1', 1, 10, 10, 9046, '【取消原因: 退款测试】', '2021-08-22 22:18:07', NULL, NULL, '17058179046', '陈亚如'),('202401120638-1001', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', '制作中', NULL, NULL, '外卖配送', '2区13舍2区10舍', '蜂蜜柚子茶[冰 大 无糖 ]*1', 1, 1300, NULL, 7841, '', '2024-01-25 04:06:38', NULL, NULL, '18862547841', '老王'),('202401195421-1001', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', '已取消', NULL, NULL, '外卖配送', '2区13舍2区10舍', '蜂蜜柚子茶[少冰 大 无糖 ]*1,芝士茉莉[冰 大 无糖 ]*1', 2, 2800, NULL, 7841, '', '2024-01-25 11:54:21', NULL, NULL, '18862547841', '老王'),('202401200235-1001', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', '已取消', NULL, NULL, '外卖配送', '2区13舍2区10舍', '蜂蜜柚子茶[常温 大 无糖 ]*1', 1, 1300, NULL, 7841, '', '2024-01-25 12:02:35', NULL, NULL, '18862547841', '老王'),('202401200602-1001', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', '制作中', NULL, NULL, '外卖配送', '2区13舍2区10舍', '蜂蜜柚子茶[常温 大 无糖 ]*1', 1, 1300, NULL, 7841, '', '2024-01-25 12:06:03', NULL, NULL, '18862547841', '老王'),('202401200847-1002', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', '制作中', NULL, NULL, '外卖配送', '2区13舍2区10舍', '百香双重奏[冰 大 无糖 ]*1', 1, 1400, NULL, 7841, '', '2024-01-25 12:08:47', NULL, NULL, '18862547841', '老王'),('202401201010-1003', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', '制作中', NULL, NULL, '外卖配送', '2区13舍2区10舍', '百香双重奏[冰 大 无糖 ]*1', 1, 1400, NULL, 7841, '', '2024-01-25 12:10:10', NULL, NULL, '18862547841', '老王'),('202401201141-1004', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', '制作中', NULL, NULL, '外卖配送', '2区13舍2区10舍', '蜂蜜柚子茶[常温 大 无糖 ]*1', 1, 1300, NULL, 7841, '', '2024-01-25 12:11:41', NULL, NULL, '18862547841', '老王'),('202401201306-1005', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', '制作中', NULL, NULL, '外卖配送', '2区13舍2区10舍', '蜂蜜柚子茶[常温 大 无糖 ]*1', 1, 1300, NULL, 7841, '', '2024-01-25 12:13:06', NULL, NULL, '18862547841', '老王'),('202401201424-1006', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', '制作中', NULL, NULL, '外卖配送', '2区13舍2区10舍', '蜂蜜柚子茶[常温 大 无糖 ]*1', 1, 1300, NULL, 7841, '', '2024-01-25 12:14:24', NULL, NULL, '18862547841', '老王'),('202401201456-1007', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', '制作中', NULL, NULL, '外卖配送', '2区13舍2区10舍', '蜂蜜柚子茶[常温 大 无糖 ]*1', 1, 1300, NULL, 7841, '', '2024-01-25 12:14:57', NULL, NULL, '18862547841', '老王'),('202401201535-1008', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', '制作中', NULL, NULL, '外卖配送', '2区13舍2区10舍', '蜂蜜柚子茶[常温 大 无糖 ]*1', 1, 1300, NULL, 7841, '', '2024-01-25 12:15:36', NULL, NULL, '18862547841', '老王'),('202401201606-1009', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', '配送中', NULL, NULL, '外卖配送', '2区13舍2区10舍', '蜂蜜柚子茶[常温 大 无糖 ]*1', 1, 1300, NULL, 7841, '', '2024-01-25 12:16:06', NULL, '2024-01-25 14:15:02', '18862547841', '老王'),('202401201747-1010', 'o30ur5JpAsAUyGBkR0uW4IxvahR8', '已送达', NULL, NULL, '外卖配送', '2区13舍2区10舍', '蜂蜜柚子茶[常温 大 无糖 ]*1', 1, 1300, NULL, 7841, '', '2024-01-25 12:17:48', NULL, '2024-01-25 14:14:49', '18862547841', '老王');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `drinkshop`.`shop_sys_role` WRITE;
DELETE FROM `drinkshop`.`shop_sys_role`;
INSERT INTO `drinkshop`.`shop_sys_role` (`id`,`name`,`description`) VALUES (1, '超级管理员', '全部权限'),(2, '后台管理员', '管理应用'),(3, '游客模式', '允许所有查看权限，拦截一切修改操作');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `drinkshop`.`shop_sys_role_permission` WRITE;
DELETE FROM `drinkshop`.`shop_sys_role_permission`;
INSERT INTO `drinkshop`.`shop_sys_role_permission` (`role_id`,`permission`) VALUES (1, '*'),(1, 'system:admin:config'),(1, 'system:admin:role'),(1, 'system:admin:sysUser'),(1, 'system:admin:timingTask'),(1, 'system:app'),(1, 'system:app:goods'),(1, 'system:app:goods:add'),(1, 'system:app:goods:update'),(1, 'system:app:goodsCategory'),(1, 'system:app:orderInfo'),(1, 'system:app:user'),(2, 'system:app'),(2, 'system:app:goods'),(2, 'system:app:goods:add'),(2, 'system:app:goods:update'),(2, 'system:app:goodsCategory'),(2, 'system:app:orderInfo'),(2, 'system:app:user');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `drinkshop`.`shop_sys_user` WRITE;
DELETE FROM `drinkshop`.`shop_sys_user`;
INSERT INTO `drinkshop`.`shop_sys_user` (`id`,`username`,`password`,`role_id`,`status`,`avatar`) VALUES (1, 'system', '4QrcOUm6Wau+VuBX8g+IPg==', 1, 1, 'userAvatar-1-31.jpg'),(2, 'admin', '4QrcOUm6Wau+VuBX8g+IPg==', 2, 1, NULL),(5, 'guest', '4QrcOUm6Wau+VuBX8g+IPg==', 3, 1, NULL),(6, 'chenyaru', 'JfnnlDI7RTiF9RgfG2JNCw==', 1, 1, NULL);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `drinkshop`.`shop_user` WRITE;
DELETE FROM `drinkshop`.`shop_user`;
INSERT INTO `drinkshop`.`shop_user` (`id`,`name`,`password`,`salt`,`address`,`gender`,`email`,`phone`,`avatar`,`nick_name`,`create_time`,`update_time`,`remark`,`status`) VALUES (7, 'dingding', '9fb4c2e34fcbd2fc5008a8de5e5c931c', 'ba822567fe8505e2dfffe81e578e1d0c', '', 0, 'watchping@163.com', '15958880027', 'http://zjffxxmt.oss-cn-hangzhou.aliyuncs.com/upload/client/2cc8d6faca8c461ea471feb2ed225018.png', '238w', '2021-05-30 12:33:31', '2022-12-06 19:58:02', '123456', 0),(8, 'dangdang', '9fb4c2e34fcbd2fc5008a8de5e5c931c', 'ba822567fe8505e2dfffe81e578e1d0c', '', 0, 'watch@163.com', '15958880026', '/images/user_default.png', 'dangdang', '2021-06-07 21:46:29', NULL, '123456', 0),(9, 'dingding2', '9fb4c2e34fcbd2fc5008a8de5e5c931c', 'ba822567fe8505e2dfffe81e578e1d0c', '', 1, 'watchping@163.com', '15958880025', '/images/user_default.png', '', '2021-06-11 14:51:37', NULL, '123456', 0),(10, 'dingding4', '9fb4c2e34fcbd2fc5008a8de5e5c931c', 'ba822567fe8505e2dfffe81e578e1d0c', '', 1, 'Wabc@13.com', '13968290224', '/images/user_default.png', 'show-password', '2021-11-30 12:12:05', NULL, '123456', 0),(14, 'dingding238', 'bce6bba6afe7f7648f3eb0919d5fcbe6', 'f254f1178fe2c4ab45ef166c3245c3e9', '', 0, 'watch@163.com', '13968290221', '/images/admin_default.png', '238', '2022-02-24 21:03:29', NULL, '123456', 0),(18, 'dingding1', 'bce6bba6afe7f7648f3eb0919d5fcbe6', 'f254f1178fe2c4ab45ef166c3245c3e9', '', 0, '234@134.com', '13968290223', '/images/user_default.png', NULL, '2022-04-03 09:29:57', NULL, 'e10adc3949ba59abbe56e057f20f883e', 0),(19, 'dingding3', 'd15cf6985ca6cefdcf59d830915f1db6', '91a9409359faaa84d7fd8d5edf45087f', '', 0, 'ding3@163.com', '13978349823', '/images/user_default.png', '123324', '2022-04-03 13:22:06', '2022-09-23 20:04:59', 'e10adc3949ba59abbe56e057f20f883e', 0),(31, 'dingding12', '5c78eea77d40fdfe1b5f8a6434b1fbc5', '616e12164bc9bb91c5e70686f52fa230', '', 1, '123456@123.com', '13978030334', 'http://zjffxxmt.oss-cn-hangzhou.aliyuncs.com/upload/client/8733262ed925464680870e00d6a2f268.png', '', '2022-10-03 21:56:18', '2022-10-03 22:08:21', '123456', 0),(32, 'dingding111', '63d9bb848b2a7d69bc990d5ce81223e1', '8c79fa851602e1b5014ccd3fc0d2221e', '', 1, '123456@123.com', '13978030222', 'http://zjffxxmt.oss-cn-hangzhou.aliyuncs.com/upload/client/2cc8d6faca8c461ea471feb2ed225018.png', 'aaaa', '2022-10-03 22:13:43', '2022-10-03 22:24:51', '123456', 0),(33, 'dingding222', 'f5dc0761b9ff66a000d2cfe7e7655ea6', '736e926307b6d32d533c19d8db59bb2a', '', 1, '222@123.com', '13903453456', '/images/user_default.png', 'AAA', '2022-10-03 22:30:26', NULL, '123456', 0),(34, 'dingding333', '5ff212e827e6675fd6dc651a7a01b2b7', 'f22041442ead17c5af3290afcdd84ef9', '', 1, '333@132.com', '13989082345', '/images/user_default.png', '', '2022-10-03 22:37:24', NULL, '123456', 0),(35, '111', '422fe9cab3911603d96dd6052648532b', '11b455249291476d8ca8f342a5b8e88f', '', 1, '1876882595@qq.com', '15372904262', '', '123', '2024-11-04 10:15:30', NULL, NULL, 0),(39, '112', '6cf506ee48daf4d155319aeab2bee56c', 'e83e1d6e1b66d842ad5f265a0e45afcc', '', 1, 'hlyyy@163.com', '15351260000', 'http://localhost:5050/profile/upload/2024/11/07/微信图片_20230203132537_20241107155011A003.jpg', '1', '2024-11-07 15:50:13', NULL, NULL, 0),(47, 'aaa', '3f6d281a16b83f4a3b40d6b3f794dfab', '75d936b08db95d5347e1fe951465f68b', 'as', 1, 'hlyyy@163.com', '15351260000', 'http://localhost:5050/profile/upload/2024/11/20/微信图片_20231229200409_20241120110333A002.jpg', 'asd', '2024-11-20 11:16:25', NULL, NULL, 0),(48, 'bb', 'c67c4405144dbc61e0bc65930917bf1a', '22b9b02d73a16dc6a8a2d785dfff7b47', 'aaaaa', 1, 'hlyyy@163.com', '15958880022', 'http://localhost:5050/profile/upload/2024/11/20/99020517293c6512658c637f56ca03e_20241120111740A001.jpg', 'xz', '2024-11-20 11:17:41', '2024-11-25 09:52:44', NULL, 0);
UNLOCK TABLES;
COMMIT;
